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.