DaveWentzel.com            All Things Data

Schemas vs Object Owners

 

schemas are not tied to any user account so you can drop a user without worrying about object ownership issues.  the schema has an owner but they do not have to share the same name. 
 
Permissions can be assigned to schemas which is nice because when you create an object you no longer have to remember to give permissions to it via a GRANT.  So a user or group is given permissions to the schema and the subsequent objects are created under that schema. 

 
 

Add new comment