HomeMogDBMogDB StackUqbar
v3.0

Documentation:v3.0

Supported Versions:

REASSIGN OWNED

Function

REASSIGN OWNED changes the owner of the database object.

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 role deletion.
  • To run the REASSIGN OWNED statement, you must have the permissions of the original and target roles.

Syntax

ReassignOwned ::= 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

None

Copyright © 2011-2024 www.enmotech.com All rights reserved.