# REASSIGN OWNED
`REASSIGN OWNED` reassigns the owner of all the objects that are owned by one of the specified roles.

> For the complete documentation index, see [llms.txt](https://preview.materialize.com/materialize/40269/llms.txt).


`REASSIGN OWNED` reassigns the owner of all the objects that are owned by one of the specified roles.

> **Note:** Unlike [PostgreSQL](https://www.postgresql.org/docs/current/sql-drop-owned.html), Materialize reassigns
> all objects across all databases, including the databases themselves.


## 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.

## Examples

```mzsql
REASSIGN OWNED BY joe TO mike;
```

```mzsql
REASSIGN OWNED BY joe, george TO mike;
```

## Privileges

The privileges required to execute this statement are:

- Role membership in `old_role` and `new_role`.

## Related pages

- [`ALTER OWNER`](https://preview.materialize.com/materialize/40269/markdown-docs/sql/index.md#rbac)
- [`DROP OWNED`](https://preview.materialize.com/materialize/40269/markdown-docs/sql/drop-owned/index.md)