Security with Views and Procedures

You can use views and stored procedures to tailor privileges to suit the needs of your enterprise.

For databases that require a high level of security, there are limitations on defining privileges directly on tables. Any privilege granted to a user on a table applies to the entire table. You may need to assign privileges more precisely than on a table-by-table basis. For example:

You do not want to give access to personal or sensitive information stored in an employee table to users who need access to other parts of the table.
You may want to give sales representatives privileges on a table containing descriptions of sales calls, but only allow them to update privileges to their own calls.

Views Provide Tailored Security
Use views to give users access to only one portion of a table.
Use Procedures to Provide Tailored Security
Procedures restrict the actions a user may take.

Parent topic: Security Management