January 10, 2013 at 1:20 pm
When I create new users, I always used the Default Schema. I have been told this is a very bad idea. Should I be creating schemas for every user I create?
January 10, 2013 at 1:35 pm
Definitely not. That was an old practice in prior versions of SQL Server, and Microsoft moved away from it in SQL 2005 and recommended against it. Use schemas for security isolation, or for application isolation, not for users.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 10, 2013 at 5:22 pm
Concur. I've almost always used the dbo schema for most applications.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply