Which two types of policies can be assigned to the policy_type argument in the dbms_rls.add_policy procedure t

Previous Question
Next Question

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.SHARED_DYNAMIC

E.
DBMS_RLS.CONTEXT_SENSITIVE

F.
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

Previous Question
Next Question

Leave a Reply

Your email address will not be published. Required fields are marked *