16.10 - Security Constraints - Teradata Database

Teradata Database Security Administration

prodname
Teradata Database
vrm_release
16.10
created_date
June 2017
category
Administration
Security
featnum
B035-1100-161K
To... the user must have the...
Create, alter, or drop CONSTRAINT objects CONSTRAINT DEFINITION privilege (system level).
  • Assign constraints to, and remove them from, users and profiles
  • Define and remove security constraint table columns in tables, views and indexes
  • Grant and revoke security constraint OVERRIDEs
CONSTRAINT ASSIGNMENT privilege (system level).

For managing security constraints for users, tables, views and indexes the user must also have the necessary CREATE/REPLACE/ MODIFY privileges on the object.

Execute the SHOW CONSTRAINT statement CONSTRAINT DEFINITION or CONSTRAINT ASSIGNMENT privilege.
Perform ARC operations on a table with security constraints OVERRIDE DUMP and OVERRIDE RESTORE on the object being archived/restored.
Bypass enforcement of security constraint UDFs OVERRIDE INSERT, OVERRIDE SELECT, OVERRIDE UPDATE, OVERRIDE DELETE for the security constraint, on the object being accessed.