REVOKE

This statement revokes system or object privileges and roles from users and roles.

To support REVOKE processing, the IP GETSUPPORT operation must return TRUE for IP_SUPPORT_REVOKE.

Syntax

REVOKE {object_priv | ALL [PRIVILEGES],...} ON {[qualifier.][owner.]object}
FROM {user | role | PUBLIC,...}

Examples

The following statement revokes the DROP ANY TABLE system privilege from the users BILL and MARY:

REVOKE DROP ANY TABLE FROM BILL, MARY; 

The following statement revokes the role CONTROLLER from the user HANSON:

REVOKE controller FROM HANSON;