Syntax for Securing Database Resources › TRANSFER OWNERSHIP › Usage

Usage

Schema Ownership

At any given time, a schema can be owned by one user or group. The initial owner is the user who created the schema. When ownership of a schema is transferred to a group, each user in the group has all the privileges associated with ownership.

Ownership of Other Resources

Technically, schemas are the only database resources that users own. However, by association, the user or group that owns a schema is also said to own the tables, functions, procedures, table procedures, views, and access modules in the schema.

Ownership Privileges

The owner of a schema has all applicable privileges on resources in the schema, as well as the privilege of granting those privileges to other users or groups. If you transfer ownership of a schema to another user or group, you no longer own the resources in the schema.

Transferring Ownership to a Single User

The following TRANSFER OWNERSHIP statement transfers ownership of the PKE_SCH schema to user PKE:

transfer ownership of schema pke_sch
   to pke;

Transferring Ownership to a Group

The following TRANSFER OWNERSHIP statement transfers ownership of the SALES schema to the SALES_GRP group:

transfer ownership of schema sales
   to sales_grp;