REASSIGN OWNED

REASSIGN OWNED changes the owner of a database.

REASSIGN OWNED requires that the system change owners of all the database objects owned by old_role to new_role.

REASSIGN OWNED is often executed before deleting a rule. Because objects in other databases are not affected, you usually need to run this command in each database that contains the objects owned by the role to be deleted.
You must have the permissions on the original and target roles to execute it.
The resource management module does not monitor the data switch of the syntax. You need to call select gs_wlm_readjust_user_space(0) to manually calibrate the monitoring data.

 REASSIGN OWNED BY old_role [, ...] TO new_role;
 

**Table 1** REASSIGN OWNED parameters
Parameter	Description	Value Range
old_role	Role name of the old owner.	A string of no more than 63 characters. Enter a string starting with a letter or underscore (_) and containing letters, digits, underscores (_), and dollar signs ($).
new_role	Name of the new role that will become the object owner.	A string of no more than 63 characters. Enter a string starting with a letter or underscore (_) and containing letters, digits, underscores (_), and dollar signs ($).

Reassign all database objects owned by the joe and jack roles to admin:

 REASSIGN OWNED BY joe, jack TO admin;
 

Parent Topic: DCL Syntax

Thank you very much for your feedback. We will continue working to improve the documentation.

The system is busy. Please try again later.