Help Center/ GaussDB/ Developer Guide(Centralized_V2.0-2.x)/ SQL Reference/ SQL Syntax/ REASSIGN OWNED
Updated on 2025-08-19 GMT+08:00
View PDF

REASSIGN OWNED

Description

Changes the owner of the database object.

REASSIGN OWNED requires that the system change the owner of all the database objects owned by an old role to a new role.

Precautions

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

Syntax

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

Parameters

  • 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