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 …]}
where:
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 …]}
Access requirements
SYS_ADMIN_ROLE role
Usage
Use the REVOKE statement to remove a role from a user, or remove privileges from a user or a role.
Note The keywords CASCADE and RESTRICT are not supported in REVOKE statements.
Examples
The following statement removes the role GUEST_USERS from the user HOBBES:
REVOKE GUEST_USERS FROM HOBBES;
The following statement removes the privilege to insert on event TEST from the role GUEST_USERS:
REVOKE INSERT ON TEST FROM GUEST_USERS;
Go up to