16.10 - About Changing Security Constraints for a User - 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 change security constraint assignments for a user in a MODIFY USER statement. When you specify a security constraint that is:

  • Not currently assigned to the user, the constraint is added to any existing constraints
  • Already assigned to the user, the new specifications replace the existing specifications
  • Already assigned to the user, followed by the keyword NULL, the constraint assignment is dropped from the user