row_level_security_constraint_column_name CONSTRAINT - Advanced SQL Engine - Teradata Database

SQL Data Definition Language Syntax and Examples

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

The name of a constraint object that you want to define as a row-level security constraint column for table_name. The constraint object must exist in the database. See CREATE CONSTRAINT.

Each specified row-level security constraint name must be unique among column names for the table.

You cannot create a row-level security constraint column for a global temporary table or for a volatile table.

A security constraint object definition includes a name, data type, and nullability specification when it is created. You cannot assign any additional attributes to a security constraint column when creating a table.

You cannot compress a row-level security constraint column using either multivalue compression or algorithmic compression. However, there are no restrictions on using auto-compression or block compression for a row-level security table with column partitions.

You can define a maximum of 5 row-level security constraint columns for a table.

When using referential integrity (RI) on tables that define security constraint columns, the system does not recognize security constraints when checking referential integrity for either the parent and child RI table. Execution of any request that access such RI tables continues as if the tables had no row-level security constraints.