About Changing Security Constraints for a User - Advanced SQL Engine - Teradata Database

Security Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
September 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
ied1556235912841.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1100
lifecycle
previous
Product Category
Teradata Vantageā„¢

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