# DROP OWNED
`DROP OWNED` drops 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).


`DROP OWNED` drops all the objects that are owned by one of the specified roles.
Any privileges granted to the given roles on objects will also be revoked.

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


## Syntax

```mzsql
DROP OWNED BY <role_name> [, ...] [RESTRICT|CASCADE];
```

Syntax element | Description
---------------|------------
`<role_name>`   | The role name whose owned objects will be dropped.
**CASCADE** | Optional. If specified, remove all dependent objects.
**RESTRICT**  | Optional. Do not drop anything if any non-index objects depencies exist. _(Default.)_

## Examples

```mzsql
DROP OWNED BY joe;
```

```mzsql
DROP OWNED BY joe, george CASCADE;
```

## Privileges

The privileges required to execute this statement are:

- Role membership in `role_name`.

## Related pages

- [`REVOKE PRIVILEGE`](https://preview.materialize.com/materialize/40269/markdown-docs/sql/revoke-privilege/index.md)
- [`CREATE ROLE`](https://preview.materialize.com/materialize/40269/markdown-docs/sql/create-role/index.md)
- [`REASSIGN OWNED`](https://preview.materialize.com/materialize/40269/markdown-docs/sql/reassign-owned/index.md)
- [`DROP CLUSTER`](https://preview.materialize.com/materialize/40269/markdown-docs/sql/drop-cluster/index.md)
- [`DROP CLUSTER REPLICA`](https://preview.materialize.com/materialize/40269/markdown-docs/sql/drop-cluster-replica/index.md)
- [`DROP CONNECTION`](https://preview.materialize.com/materialize/40269/markdown-docs/sql/drop-connection/index.md)
- [`DROP DATABASE`](https://preview.materialize.com/materialize/40269/markdown-docs/sql/drop-database/index.md)
- [`DROP INDEX`](https://preview.materialize.com/materialize/40269/markdown-docs/sql/drop-index/index.md)
- [`DROP MATERIALIZED VIEW`](https://preview.materialize.com/materialize/40269/markdown-docs/sql/drop-materialized-view/index.md)
- [`DROP SCHEMA`](https://preview.materialize.com/materialize/40269/markdown-docs/sql/drop-schema/index.md)
- [`DROP SECRET`](https://preview.materialize.com/materialize/40269/markdown-docs/sql/drop-secret/index.md)
- [`DROP SINK`](https://preview.materialize.com/materialize/40269/markdown-docs/sql/drop-sink/index.md)
- [`DROP SOURCE`](https://preview.materialize.com/materialize/40269/markdown-docs/sql/drop-source/index.md)
- [`DROP TABLE`](https://preview.materialize.com/materialize/40269/markdown-docs/sql/drop-table/index.md)
- [`DROP TYPE`](https://preview.materialize.com/materialize/40269/markdown-docs/sql/drop-type/index.md)
- [`DROP VIEW`](https://preview.materialize.com/materialize/40269/markdown-docs/sql/drop-view/index.md)