Using views to filter sensitive data

You can use views to filter sensitive data from certain users.

Creating a view
Use the CREATE VIEW statement to create a view.
Granting privileges for a view
As with tables, you can grant SELECT, INSERT, UPDATE, and DELETE privileges on a view.

Parent topic: Creating and maintaining objects in the database