15.10 - VALUES - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K

The string to follow is a set of name:value pairs, which defines either a hierarchical (level) or non-hierarchical (category) classification system.

The set of name:value pairs defines the set of classifications for the constraint.

The maximum number of name :value pairs depends on whether the constraint is hierarchical (10,000) or non-hierarchical (256).

name
The name of a member of the classification system being defined for the constraint.
One or more of the classification names for the constraint can be assigned to a user or profile to define their access privileges on tables that contain the constraint.
value
The value code for the corresponding name in a name:value pair.
Value codes appear for each row in the corresponding constraint column of tables protected by the constraint.
For details about name:value pairs and how the value is determined for a table row, see “Implementing Row-Level Security” in Resource Usage Macros and Tables, B035-1099.