REASSIGN OWNED¶
Function¶
Changes the owner of a database.
REASSIGN OWNED requires that the system changes the owner of all the database objects owned by old_role to new_role.
Precautions¶
REASSIGN OWNED is often executed before deleting a role. 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.
Syntax¶
REASSIGN OWNED BY old_role [, ...] TO new_role;
Parameter Description¶
old_role
Specifies the role name of the old owner.
new_role
Specifies the role name of the new owner.
Examples¶
Reassign all database objects owned by the joe and jack roles to admin:
REASSIGN OWNED BY joe, jack TO admin;