17.10 - View Requirements - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Advanced SQL Engine Security Administration

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

When a user accesses a view, the system enforces all security constraints in the base table(s) referenced by the view, whether or not the view contains the security constraint columns.

A CREATE VIEW or REPLACE VIEW statement can reference both RLS and non-RLS base tables, but all of the RLS base tables must contain the same security constraints or the system returns an error.

If you add or change security constraints in base tables referenced by a view, and as a result the RLS tables no longer contain matching sets of security constraints, subsequent requests to access the view fail with an error.