Row-Level Security and UDF Enforcement | CREATE/REPLACE FUNCTION | Vantage - 17.10 - Row-Level Security UDF Enforcement of the Security Policy for a Row - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Detailed Topics

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)

The database executes the row-level security policy function you assign to the constraint object that corresponds to a table column to enforce the security policy for a data row. You can create a scalar function for each of the four request types (DELETE, INSERT, SELECT, UPDATE) that can be executed against the table on which the security constraint is defined.

See Teradata Vantage™ - SQL External Routine Programming, B035-1147 for information about how to write row-level security policy UDFs.

See Teradata Vantage™ - Advanced SQL Engine Security Administration, B035-1100 for general information about row-level security.