Limits on Applying Security Constraints to Tables - Advanced SQL Engine - Teradata Database

Security Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2022-02-15
dita:mapPath
ppz1593203596223.ditamap
dita:ditavalPath
wrg1590696035526.ditaval
dita:id
B035-1100
lifecycle
previous
Product Category
Teradata Vantageā„¢

A maximum of 5 security constraints can be defined for a table.

A security constraint column cannot be part of a primary index or a partitioning expression, but can participate in a secondary index.

Join indexes and hash indexes must include all constraint columns in the base table.

Limits on CHECK or UNIQUE table constraints:

  • If a table protected by row level security is defined with a CHECK or UNIQUE constraint, enforcement of the constraint bypasses any security constraints defined for the table.
  • You cannot define a CHECK or UNIQUE constraint on a security constraint column.

Do not define row level security on a parent or child referential integrity (RI) table.

If either or both the parent and child RI tables define security constraint columns, the security constraint UDFs are disabled and execution of any request that accesses either of the RI tables continues as if the tables had no row level security constraints.