February 9, 2010 at 12:49 am
Under sql 2008 creating a new database creates a schema called db_datareader. The owner of this schema is "db_datareader". The owner of the role named "db_datareader" is "dbo".
1. How is all that spaghetti related?
2. What are the consequences of making the owner of all schemas in a databse "dbo"?
TIA,
barkingdog
February 9, 2010 at 1:11 am
February 9, 2010 at 5:57 am
Barkingdog (2/9/2010)
Under sql 2008 creating a new database creates a schema called db_datareader. The owner of this schema is "db_datareader". The owner of the role named "db_datareader" is "dbo".1. How is all that spaghetti related?
2. What are the consequences of making the owner of all schemas in a databse "dbo"?
The owner of that schema is NOT dbo, it's db_datareader, which is considerably less privileged than dbo.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply