October 13, 2008 at 12:12 am
in what way the ownership of objects has been changed in 2005 through schema.
what permissions does an schema inherit when a new schema is created?
does the user permissions inherit to the schema when he is made the schema owner?
thanks in advance...
replies are appreciated.....
October 14, 2008 at 9:26 am
The main change is that schemas are no longer bound to users, users are assigned a default schema though.
To my knowledge a schema does not inherit any persmissions when a new schema is created. Schemas do not have permissions, users/roles are assigned permissions against schemas.
A schema does not inherit permissions from a user a user is granted permissions through a schema. If UserA is the owner of SchemaA then UserA has full rights on any and all objects created in SchemaA, but SchemaA is not granted any rights to any other objects the UserA has rights to, except through ownership chaining. If UserA owns SchemaA and SchemaB then Users with execute permissions on stored procedures/functions in SchemaA will be able to access objects in SchemaB and vice-versa without being granted explicit rights on those objects.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
October 14, 2008 at 6:15 pm
thanks jack...
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply