SQL Server - Object

Card Puncher Data Processing

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.





Discover More
Card Puncher Data Processing
SQL Server - Database Owner (dbo) user

The dbo is a user that has implied permissions to perform all activities in the database. Any member of the sysadmin fixed server role who uses a database is mapped to the special user inside each database...
Card Puncher Data Processing
SQL Server - Schema

The new schema is owned by one of the following database-level principals: database user, database role, or application role. Objects created within a schema are owned by the owner of the schema....



Share this page:
Follow us:
Task Runner