16.10 - View Requirements - Teradata Database

Teradata Database Security Administration

Product
Teradata Database
Release Number
16.10
Release Date
June 2017
Content Type
Administration
Security
Publication ID
B035-1100-161K
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.