16.10 - Restricting User Access Using Views - Teradata Database

Teradata Database Security Administration

prodname
Teradata Database
vrm_release
16.10
created_date
June 2017
category
Administration
Security
featnum
B035-1100-161K

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.