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.
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.
►►─── TRANSFER OWNERSHIP OF SCHEMA schema-name ───────────────────────────────► ►─── TO authorization-identifier ────────────────────────────────────────────►◄
Specifies the schema whose ownership is being transferred. Schema-name must identify a schema defined in the dictionary.
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.
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.
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;
|
Copyright © 2014 CA.
All rights reserved.
|
|