16.20 - About Row Level Security - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL External Routine Programming

Product
Advanced SQL Engine
Teradata Database
Release Number
16.20
Release Date
April 2020
Content Type
Programming Reference
Publication ID
B035-1147-162K
Language
English (United States)

Teradata Database provides row level security as one way of controlling access to tables and views. Teradata row level security controls user access by row and by SQL operation. Access rules are based on the relationship between the user access level and the row security level.

The following steps show the basic process for implementing row level security:

  1. Determine security classifications that will be used to define security labels for users and data rows.
  2. Create security constraint UDFs to define and enforce row level security restrictions.
  3. Create security constraint objects and specify the appropriate security UDF to control an INSERT, SELECT, UPDATE or DELETE operation. For more information, see “CREATE CONSTRAINT” in Teradata Vantage™ - SQL Data Definition Language Detailed Topics , B035-1184 .
  4. Assign security constraints to tables and users.

For more information about Teradata row level security, see Teradata Vantage™ - Advanced SQL Engine Security Administration, B035-1100.