REVOKE

Specifying revokes DELETE, and SELECT privileges.

Specifying ROLE PUBLIC revokes privileges from the PUBLIC role. Users will retain privileges assigned to them directly or via other roles.

For REVOKE statement to succeed, the user executing it should possess the specified privileges as well as the for those privileges.

Revoke INSERT and SELECT privileges on the table orders from user alice:

Revoke all privileges on the table test from user alice:

Some connectors have no support for . See connector documentation for more details.