16.10 - DBC Security Constraint Tables and Views - 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)
Table and Related Views Description
  • DBC.SecConstraints
  • DBC.SecConstraintsV and VX
Contains information about all security constraint objects defined for the system.
  • DBC.ConstraintFunctions
  • DBC.ConstraintFunctionsV
Identifies the UDFs for each constraint object.
Details for the UDFs are in DBC.UDFInfo.
  • DBC.ConstraintValues
  • DBC.ConstraintValuesV
Defines the set of valid name:value pairs for each constraint object.
  • DBC.AsgdSecConstraints
  • DBCUsrAsgdConstraintsV and VX
  • DBC.ProfileAsgdConstraintsV and VX
Defines the name:value pairs assigned to each user or profile, by constraint object name.
  • DBC.TVFieldsV
  • DBC.ColumnsV
Contains a row for every column in a database table, view, or index.

The ConstraintID column indicates whether a column is a security constraint.

DBC.AccLogRulesV Indicates whether a logging rule is for a security constraint related privilege, and contains a column for each row level security privilege.