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. |