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.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply