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
|For information on...||See...|
|creating views||SQL Data Definition Language Syntax and Examples.|
|using views||Database Administration.|