REASSIGN OWNED
REASSIGN OWNED reassigns the owner of all the objects that are owned by one of the specified roles.
NOTE: Unlike PostgreSQL, Materialize reassigns
all objects across all databases, including the databases themselves.
Syntax
REASSIGN OWNED BY <current_owner> [, ...] TO <new_owner>;
| Syntax element | Description |
|---|---|
<current_owner> |
The role whose objects are to be reassigned. |
<new_owner> |
The role name of the new owner of these objects. |
Examples
REASSIGN OWNED BY joe TO mike;
REASSIGN OWNED BY joe, george TO mike;
Privileges
The privileges required to execute this statement are:
- Role membership in
old_roleandnew_role.