REASSIGN OWNED
Attention
This page documents an earlier version. Go to the latest (v2.3) version.Synopsis
Use the REASSIGN OWNED
statement to change the ownership of database objects owned by any of the old_roles
to new_role
.
Syntax
reassign_owned ::= REASSIGN OWNED BY role_specification [ , ... ] TO
role_specification
role_specification ::= role_name | CURRENT_USER | SESSION_USER
reassign_owned
role_specification
Semantics
REASSIGN OWNED
is typically used to prepare for the removal of a role. It requires membership on both the source roles and target role.
Examples
- Reassign all objects owned by john to yugabyte.
yugabyte=# reassign owned by john to yugabyte;