16.10 - Revoking SQL DML OVERRIDE Privileges - Teradata Database

Teradata Database Security Administration

Product
Teradata Database
Release Number
16.10
Release Date
June 2017
Content Type
Administration
Security
Publication ID
B035-1100-161K
Language
English (United States)

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.