Ownership of Database Objects

Ownership of Database Objects

Each database object is owned by either a user or a role.  If the owner is a role, the object is co-owned by every user belonging to that role.

Each object also has privileges associated with it.  A privilege grants a particular authority to an object for either an individual user or for all users belonging to a particular role.

Depending on the privileges defined in the database, you can view objects that you do not own.  For example, you can include on a database diagram an object owned by another user.  When such an object appears on a diagram or in the Table Designer, it is labeled with the owner name as well as the object name.

If the database privileges let you view but not modify the database structure, you can use change scripts to design your modifications without transmitting them to the database.  For more information, see Saving a Change Script.

For details about changing the owner of a table or view, see Tables Property Page and Query Tab, Properties Window (View Designer), respectively.