SQL Server - Object

Management

Owner

Objects created within a schema are owned by the owner of the schema, and have a NULL principal_id in sys.objects.

Ownership of schema-contained objects can be transferred to any database-level principal, but the schema owner always retains CONTROL permission on objects within the schema.

Full Qualification Name rules

If user Andrew is a member of the sysadmin fixed server role and creates a table T1, T1 belongs to dbo and is qualified as

dbo.T1

, not as

Andrew.T1

.

Conversely, if Andrew is not a member of the sysadmin fixed server role but is a member only of the db_owner fixed database role and creates a table T1, T1 belongs to Andrew and is qualified as

Andrew.T1

. The table belongs to Andrew because he did not qualify the table as dbo.T1.

Only objects created by members of the sysadmin fixed server role (or by the dbo user) belong to dbo. Objects created by any other user who is not also a member of the sysadmin fixed server role (including members of the db_owner fixed database role):

  • Belong to the user creating the object, not dbo.
  • Are qualified with the name of the user who created the object.

Powered by ComboStrap