Lu, Huayi a24ca60074 DWS DEVELOPER 811 version

Reviewed-by: Hasko, Vladimir <vladimir.hasko@t-systems.com>
Co-authored-by: Lu, Huayi <luhuayi@huawei.com>
Co-committed-by: Lu, Huayi <luhuayi@huawei.com>

2023-01-19 13:37:49 +00:00

4.7 KiB

Raw Permalink Blame History

REASSIGN OWNED

Function

REASSIGN OWNED changes the owner of a database.

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

Precautions

REASSIGN OWNED is often executed before deleting a rule.
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

1
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.

1
REASSIGN OWNED BY joe, jack TO admin;

Parent topic: DCL Syntax

4.7 KiB Raw Permalink Blame History