system schemas owned by user

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » Security (SS2K8) » system schemas owned by user

system schemas owned by user

Rate Topic

Display Mode

Topic Options

Author

Message

sierra4

Posted Tuesday, August 14, 2012 10:28 AM

SSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 5:50 AM
Points: 34, Visits: 420

Hello,
In one of our databases, the following schemas are showing as owned by a regular user:
db_datareader
db_denydatawriter
db_owner

the other schemas though, like db_ddladmin, is owned by itself -- ddlamin.

can i simply change the schemas listed above to be owned by itself? meaning, db_datareader will be owned by db_datareader?

thank you

Post #1344861

Steve Jones - SSC Editor

Posted Tuesday, August 14, 2012 10:36 AM

SSC-Dedicated

Group: Administrators
Last Login: Today @ 4:46 PM
Points: 31,433, Visits: 13,745

I think so. Test it first on a backup, but all of my schemas like that are owned by themselves.

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #1344868

sierra4

Posted Wednesday, August 15, 2012 1:05 PM

SSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 5:50 AM
Points: 34, Visits: 420

yes, i tested it first, and then implemented it in production -- haven't heard any issues [yet].

thanks!

Post #1345493

« Prev Topic | Next Topic »

Permissions