Updated on 2022-07-29 GMT+08:00

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

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;