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.
|role_name||The role name whose owned objects will be dropped.|
|CASCADE||Remove all dependent objects.|
|RESTRICT||Don’t remove anything if any non-index objects depencies exist. (Default.)|
DROP OWNED BY joe;
DROP OWNED BY joe, george CASCADE;
The privileges required to execute this statement are:
- Role membership in