Transfer Ownership
Go Up to Available object actions by DBMS
An object owner or a user with SECADM authority can transfer ownership of an object to another user. The new user is automatically granted the same privileges as the former owner. Ownership can be transferred on an object-by-object basis or you can transfer all objects currently owned by an individual user.
Platform Availability and object type support
- DB2 LUW 9.1 ^
The following table lists the object types that support ownership transfer:
|
Aliases |
Check Constraints |
Event Monitors |
Foreign Keys |
|
Functions |
Indexes |
Primary Keys |
Procedures |
|
Materialized Query Tables |
Schema |
Sequences |
Structured Types |
|
Tables |
Tablespaces |
Triggers |
Unique Keys |
|
User Datatypes |
Views |
To Transfer Ownership of an Object
- Initiate a Transfer Ownership action against one or more supported objects (see table above). For more information see Initiating an object operation.
- Use the following table as a guide to understanding and modifying settings in the Transfer Ownership wizard:
| Step | Settings and tasks | |
|---|---|---|
|
Action options |
If you initiated the ownership transfer against a user, select the specific objects belonging to that user that are to be assigned to a new user. Use the New Owner dropdown to select a defined user as the new owner of the selected object or objects. | |
|
Preview |
Preview the DDL generated for the operation. For more information, see Preview. | |