DBC Security Constraint Tables and Views | Teradata Vantage - DBC Security Constraint Tables and Views - 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ā„¢
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.