16.10 - Revoking ARC 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 an ARC OVERRIDE privilege from users or roles on a database or table for which they currently have the privilege. For example:

REVOKE OVERRIDE [DUMP|RESTORE] CONSTRAINT
ON  object_nameFROM  user_name  ...[, user_name]|role_name  ...[, role_name]

where

Syntax Element Description
OVERRIDE [DUMP|RESTORE] CONSTRAINT The type of ARC override (DUMP or RESTORE).
object_name The name of a database or table on which the ARC OVERRIDE privilege is revoked.
user_name ...[, user_name] | role_name ...[, role_name] The user(s) or role(s) from which the OVERRIDE privileges are revoked.