Evil Kraig F (8/8/2012)

---

SQLSACT (8/7/2012)

---

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

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: