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

SQL Data Definition Language Detailed Topics

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2024-12-13
dita:mapPath
vuk1628111288877.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
jbg1472252759029
lifecycle
latest
Product Category
Teradata Vantage™

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™ - Analytics Database Security Administration, B035-1100 for general information about row-level security.