Ownership

Restriction: This topic applies to Windows environments only.

Implicit privileges exist for the owner of an object. For example, the owner of a table has all privileges on that table, including the privilege to drop or alter it. The default owner of an object is the SQLID at the time the object is created. However, a different owner can be recorded by using an AuthID to qualify the object (in the form creator-authid.object-name) when creating the object. For example, using the table name smith.orders when issuing a CREATE TABLE statement creates a table called orders that is owned by the AuthID smith. For additional information on ownership of a particular object, see the appropriate CREATE statement in the command reference topic of this manual.

Note:

If security is turned off, the server uses the default SQLID of the client as the creator of any database objects, and the grantor of privileges.