17.10 - Restricting User Access Using Views - 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)

Database tables may contain information that is needed by the general user population, as well as other information to which access must be highly restricted.

You can create:
  • Views to omit columns containing proprietary data, while including other columns.
  • Multiple views for the same table, where:
    • Many users have SELECT privileges on a view of the entire table
    • Some users have INSERT, UPDATE, or DELETE privileges on a view that includes only part of the table

Related Information

For information on... See...
creating views Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144.
using views Teradata Vantage™ - Database Administration, B035-1093.