16.10 - Granting Security Constraint Administrative 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)

Use the GRANT statement (SQL form) to assign system level security constraint administrative privileges to a user or role. For example:

GRANT [CONSTRAINT DEFINITION|CONSTRAINT ASSIGNMENT]
TO [admin_user_name  (WITH GRANT OPTION)|admin_role_name] ;

where:

Privilege Description
CONSTRAINT DEFINITION Allows the user to CREATE, ALTER, or DROP CONSTRAINT objects, and execute the SHOW CONSTRAINT statement.
CONSTRAINT ASSIGNMENT Allows the user to:
  • Assign CONSTRAINT values to users and profiles
  • Grant and revoke constraint override privileges
  • Define security constraint columns in tables
  • Execute the SHOW CONSTRAINT statement
[admin_user_name|admin_role_name] The administrative user or role (grantee) receiving the privilege
WITH GRANT OPTION Allows the grantee to grant the row level security administrative privilege(s) to other users or roles.
WITH GRANT OPTION is not applicable to role grants.