16.10 - Revoking SQL DML OVERRIDE Privileges - Teradata Database

Teradata Database Security Administration

Teradata Database
Release Number
Release Date
June 2017
Content Type
Publication ID
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]


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.