This statement pair revokes all SQL privileges on the accounting database and all monitor privileges on the system from a user named ted. This example assumes that the revoker has the necessary privileges either implicitly or explicitly WITH GRANT OPTION.
REVOKE ALL PRIVILEGES ON accounting FROM ted; REVOKE MONITOR PRIVILEGES FROM ted;
Example of Revoking Specific Privileges From a User
This statement revokes the ABORTSESSION, MONSESSION, and SETSESSRATE monitor privileges from user pls. This example assumes that the revoker has the necessary privileges either implicitly or explicitly WITH GRANT OPTION.
REVOKE ABORTSESSION, MONSESSION, SETSESSRATE FROM pls;
For information about granting monitor privileges, see GRANT (Monitor Form).