16.10 - Revoking SQL DML OVERRIDE Privileges - Teradata Database

Teradata Database Security Administration

prodname
Teradata Database
vrm_release
16.10
created_date
June 2017
category
Administration
Security
featnum
B035-1100-161K

You can revoke OVERRIDE privileges with the REVOKE (SQL form) statement. For example:

REVOKE OVERRIDE [sql_statement_type  ... [, sql_statement_type]]
CONSTRAINT [constraint_name  ... [, constraint_name]]
ON [object_name]
FROM  user_name  ...[, user_name]|role_name  ...[, role_name]

where

Syntax Element Description
  • [sql_statement_type ...
  • [, sql_statement_type]]
The SQL statement type(s) for which OVERRIDE privileges are revoked, INSERT, SELECT, UPDATE, or DELETE.

If no SQL statement is specified, the OVERRIDE privilege is revoked for all SQL statement types.

  • [ constraint_name ...
  • [, constraint_name]]
The row level security constraints for which the OVERRIDE privilege(s) are revoked.

If no security constraints are specified, the OVERRIDE privileges are revoked from all affected objects.

  • object_name
The object on which the OVERRIDE privileges are revoked.

You must specify an object or the system returns an error.

  • user_name ...[, user_name] |
  • role_name ...[, role_name]
The user(s) or role(s) from which the OVERRIDE privilege(s) are revoked.