Restricting User Access Using Views - Advanced SQL Engine - Teradata Database

Security Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
September 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
ied1556235912841.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1100
lifecycle
previous
Product Category
Teradata Vantage™

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.