15.10 - Example: Logging Denials for a Row-Level Security Constraint - 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

This example logs denials when a user attempts to access any table that has the classification_category constraint, if the user does not have the OVERRIDE SELECT CONSTRAINT privilege.

     BEGIN LOGGING DENIALS 
     ON EACH OVERRIDE SELECT
     FOR CONSTRAINT classification_category;