11.5 Enabling Row-Level Data Security Policy

Learn about where and when to use a row-level data security policy.

Imagine you are asked to implement a new feature with the following requirements:

• Managers should also be able to access the Salary Review page
• The page should display only their direct or indirect reports
• The employee data is read-only for managers.

You tackle this by creating two new authorization schemes, and combining them with a powerful Oracle database feature: policy-driven, row-level data security.

• Using SQL and PL/SQL Authorization Rules
  Use SQL or PL/SQL to define custom authorization schemes.
• Enabling Row-Level Data Security
  To define row-level security policies on tables or views, your workspace's parsing schema needs additional privileges your DBA can grant.