Example of Revoking All Privileges from a User - Database Engine 20 - Teradata Vantage

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).