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

Security Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2022-02-15
dita:mapPath
ppz1593203596223.ditamap
dita:ditavalPath
wrg1590696035526.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.