Materialize/doc/user/content/sql/reassign-owned.md

---

title: "REASSIGN OWNED" description: "REASSIGN OWNED reassigns the owner of all the objects that are owned by one of the specified roles." menu: main:

parent: commands

---

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

{{< diagram "reassign-owned.svg" >}}

Field	Use
_oldrole	The role name whose owned objects will be reassigned.
_newrole	The role name of the new owner of all the objects.

Examples

REASSIGN OWNED BY joe TO mike;

REASSIGN OWNED BY joe, george TO mike;

Privileges

The privileges required to execute this statement are:

{{< include-md file="shared-content/sql-command-privileges/reassign-owned.md"

}}

Related pages

• ALTER OWNER
• DROP OWNED