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. {{< /note >}}

Syntax

mzsql

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.

mzsql

REASSIGN OWNED BY joe TO mike;

mzsql

REASSIGN OWNED BY joe, george TO mike;

The privileges required to execute this statement are:

{{% include-headless "/headless/sql-command-privileges/reassign-owned" %}}