Which statement regarding the implementation of shared policy functions is correct?
A.
The policies need to have the same name.
B.
The policy type must be DBMS_RLS.DYNAMIC.
C.
The shared policy function can be enforced on any number of objects.
D.
The shared policy function cannot be enforced on more than two objects.
Explanation:
Both static and context-sensitive policies can be shared across multiple database objects, so that queries on another database object can use the same cached predicate. Shared policies enable you to further decrease the overhead of reexecuting policy functions for every query, reducing any performance impact.REF: Oracle(r) Database Security Guide, xxviii
I have the same idea.