Security - Owned Schemas

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » Security (SS2K8) » Security - Owned Schemas

Security - Owned Schemas

Rate Topic

Display Mode

Topic Options

Author

Message

SQLSACT

Posted Tuesday, August 07, 2012 12:04 AM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 8:22 AM
Points: 1,258, Visits: 2,232

Hi All

I'm trying to understand something regarding SQL Server security

If I have a SQL Login and that Login is also a user on a database. What happens when that user owns schemas in the Database? What does that mean?

Thanks

Post #1341019

Evil Kraig F

Posted Wednesday, August 08, 2012 10:55 AM

SSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 5:35 PM
Points: 5,722, Visits: 6,194

SQLSACT (8/7/2012)

It means they can create objects within that schema under that login, as well as access anything that the owner of the schema can with 'execute as owner' (the default if unspecified). So, if the schema owner were a DBO or had data_reader on dbo tables, anything created in that schema would inherit the rights.

It gets complicated from there. Hehe

- Craig Farrell

Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

For better assistance in answering your questions | Forum Netiquette
For index/tuning help, follow these directions. |Tally Tables
Twitter: @AnyWayDBA

Post #1342033

SQLSACT

Posted Friday, August 10, 2012 4:36 AM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 8:22 AM
Points: 1,258, Visits: 2,232

Evil Kraig F (8/8/2012)

SQLSACT (8/7/2012)

Thanks

I have a lot to learn about this

Post #1343263

« Prev Topic | Next Topic »

Permissions