16.10 - Restricting User Access Using Views - Teradata Database

Teradata Database Security Administration

Teradata Database
Release Number
Release Date
June 2017
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 SQL Data Definition Language Syntax and Examples.
using views Database Administration.