You want to enforce a company’s business policy on several objects by using a single policy function.
Which two types of policies can be assigned to the policy_type argument in the dbms_rls.add_policy procedure to achieve the above objective? (Choose two.)
A.
DBMS_RLS.STATIC
B.
DBMS_RLS.DYNAMIC
C.
DBMS_RLS.SHARED_STATIC
D.
DBMS_RLS.CONTEXT_SENSITIVE
E.
DBMS_RLS.SHARED_CONTEXT_SENSITIVE
Explanation:
DBMS_RLS. SHARED_STATIC The policy function executes once, Once, then the predicate is cached in the SGA, and it’s Shared Across Multiple Objects, like Hosting environments, such as data warehouses where the same predicate must be applied to multiple database objects DBMS_RLS. SHARED_CONTEXT_SENSITIVE The policy function executes f irst time and the object is reference in a database session Predicates are cached in the private session memory UGA so policy functions can be shared among objects.
REF: Oracle(r) Database Security Guide 10g Release 2 (10.2) – p 15-30