DROP OWNED
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, Materialize drops
all objects across all databases, including the database itself.
Syntax
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
DROP OWNED BY joe;
DROP OWNED BY joe, george CASCADE;
Privileges
The privileges required to execute this statement are:
- Role membership in
role_name.