16.10 - Revoking ARC 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 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.