Help Center/ GaussDB/ Developer Guide(Distributed_3.x)/ SQL Reference/ SQL Syntax/ REASSIGN OWNED
Updated on 2024-05-07 GMT+08:00
View PDF
Share

REASSIGN OWNED

Function

Changes the owner of the database object.

REASSIGN OWNED changes the database object owner of an old role to a new role.

Precautions

  • REASSIGN OWNED is often executed before role deletion.
  • To run the REASSIGN OWNED statement, you must have the permissions of the original and target roles.

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. Note: Only the initial user can use the REASSIGN OWNED syntax to change the owner to the initial user.

Examples

None

Parent topic: SQL Syntax