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

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.