Ownership Privileges of Database Objects

Ownership of a database object carries with it privileges to carry out actions on that object.

The creator of a database object may not necessarily be its owner. Another user can be designated as owner during the create process. If no owner is specified, the creator is the owner.

The owner of a table can modify the table structure, for instance, or can grant privileges to other database users to update the information within the table.

Note: The owner of a table can load data if he or she has sufficient privilege, or if the server was started with the -gl all switch on the command line or configuration file. Ownership or the CREATE ANY OBJECT system privilege are insufficient to issue the LOAD TABLE command; the INSERT privilege on the table is also required.

A user with the ALTER ANY OBJECT system privilege can modify any database object (regardless of owner) that can be created using the CREATE ANY OBJECT system privilege. A user with the CREATE ANY OBJECT system privilege can create database objects to be owned by other users.