November 15, 2012 at 11:32 am
What does authorization in CREATE SCHEMA test AUTHORIZATION dbo really do?
We create schema and grant authorization to dbo for all schema. Is this how it's usually done?
November 16, 2012 at 2:19 am
It specifies who you want the owner of the schema to be.
So it says that the schema is owned by the dbo login.
You can grant authoirzation to any valid login but I have yet to work in a place that grants ownership to anyone other than dbo.
November 16, 2012 at 6:34 am
We have schema's owned by local DB users without logins to control access to specific schema objects. From my understanding loginless users work like application roles but we can audit specifically which individual login was used to impersonate the user. That loginless user has access to objects in that particular schema it owns but regular logins do not have access to those objects. That's my basic understanding. If anyone has a clearer/other use I'd like to hear them. Thanks.
---------------------------------------------------------------
Mike Hahn - MCSomething someday:-)
Right way to ask for help!!
http://www.sqlservercentral.com/articles/Best+Practices/61537/
I post so I can see my avatar :hehe:
I want a personal webpage 😎
I want to win the lotto 😀
I want a gf like Tiffa :w00t: Oh wait I'm married!:-D
November 16, 2012 at 6:52 am
So if "create schema abc authorization dbo" would grant ownership of objects to dbo schema. Does this mean anyone with access to dbo schema would have access to objects owned by schema "abc"?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply