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

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.