Help Center > > Developer Guide> SQL Reference> SQL Syntax> DROP OWNED

DROP OWNED

Updated at: Mar 13, 2020 GMT+08:00

Function

DROP OWNED deletes the database objects of a database role.

Precautions

The role's permissions on all the database objects in the current database and shared objects (databases and tablespaces) will be revoked.

Syntax

1
DROP OWNED BY name [, ...] [ CASCADE | RESTRICT ];

Parameter Description

  • name

    Specifies the role name.

    Valid value:

  • CASCADE | RESTRICT
    • CASCADE: automatically deletes all objects that depend on the objects to be deleted.
    • RESTRICT (default): refuses to delete the object if any objects depend on it.

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel