17.10 - View Requirements - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Advanced SQL Engine Security Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Administration
Security
Publication ID
B035-1100-171K
Language
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.