TRANSFER OWNERSHIP

The TRANSFER OWNERSHIP authorization statement passes ownership of a schema from one user or group of users to another. It is also a CA IDMS extension of the SQL standard.
idmscu19
The TRANSFER OWNERSHIP authorization statement passes ownership of a schema from one user or group of users to another. It is also a CA IDMS extension of the SQL standard.
Authorization
To issue a TRANSFER OWNERSHIP statement, you must own the schema named in the statement or hold the DBADMIN privilege on the database in which the schema is defined.
Syntax
  ►►─── TRANSFER OWNERSHIP OF SCHEMA 
schema-name
 ───────────────────────────────►  ►─── TO 
authorization-identifier
 ────────────────────────────────────────────►◄  
Parameters
  • OF SCHEMA
    schema-name
    Specifies the schema whose ownership is being transferred.
    Schema-name
    must identify a schema defined in the dictionary.
  • TO authorization-identifier
    Identifies the user or group of users to whom you are transferring ownership of the named schema. For expanded
    authorization-identifier
    syntax, see Expansion of Authorization-identifier.
Usage
Schema Ownership
At any given time, a schema can be owned by one user or group of users. 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 Entities
Technically, schemas are the only database entities that users own. However, by association, the user or group that owns a schema is also said to own the entities in the schema.
Ownership Privileges
The owner of a schema has all applicable privileges on entities 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 have any privileges on the entities in the schema.
Examples
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_SCH schema to the SALES_GRP group:
transfer ownership of schema sales    to sales_grp;
More Information
  • For more information about creating a schema, see CREATE SCHEMA.
  • For more information about schema ownership, see your security administrator.