Revokes system-wide performance monitoring privileges.
REVOKE MONITOR takes effect immediately when the revoked users issue their next statement.
Required Privileges
For REVOKE (Monitor), the user submitting a REVOKE statement must have all the privileges that are to be revoked with GRANT option.
Syntax
REVOKE [ GRANT OPTION FOR ] { MONITOR [ PRIVILEGES | BUT NOT monitor_privilege [,...] ] | monitor_privilege [,...] } { TO | FROM } { revokee [,...] | PUBLIC } [;]
- revokee
-
[ALL] user_name
Syntax Elements
- GRANT OPTION FOR
- Indicates that only the grant authority is removed from the specified privileges for the specified grantees.
- MONITOR PRIVILEGES
- Revokes from the specified user all privileges, except MONITOR, that can be granted on the specified object, and that are possessed WITH GRANT OPTION by the user executing the REVOKE.
- MONITOR BUT NOT
- Revokes all of the MONITOR privileges except those specified by monitor_privilege.
- monitor_privilege
- The monitoring privileges that are to be revoked.
- ALL
- Indicates that the monitoring privileges are to be to revoked from the named database or user, and every database or user owned by that database or user now and in the future.
- user_name
- The database or user from whom monitoring privileges are to be revoked. You can specify up to 25 names.
- PUBLIC
- Indicates that the monitoring privileges are to be revoked from all currently defined and future Teradata Database users.
Example of Revoking All Privileges From a User
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).