REVOKE
REVOKE { role_name [, role_name ]... }
FROM {PUBLIC | user_name [, user_name ]... }
REVOKE
{ALL | revoke_privilege [, revoke_privilege]... } ON table-name
FROM {PUBLIC | user_name [, user_name]... |
role_name [, role_name]... }
revoke-privilege ::= DELETE | INSERT | SELECT |
UPDATE [( column_identifier [, column_identifier]... )] |
REFERENCES
REVOKE EXECUTE ON procedure_name
FROM {PUBLIC | user_name [, user_name]... | role_name
[, role_name]... }
REVOKE {SELECT | INSERT} ON event_name FROM
{PUBLIC | user_name [, user_name]... | role_name
[, role_name]... }
REVOKE {SELECT | INSERT} ON sequence_name
FROM {PUBLIC | user_name [, user_name]... |
role_name [, role_name]... }
Usage
The REVOKE statement removes a role from users or privileges from users and roles.
Note The keywords CASCADE and RESTRICT are not supported in REVOKE statements.
Examples
The following command removes the role GUEST_USERS from the user HOBBES:
REVOKE GUEST_USERS FROM HOBBES;
The following command removes the privilege to insert on event TEST from the role GUEST_USERS:
REVOKE INSERT ON TEST FROM GUEST_USERS;
Related reference
Related information
See also