Policy utilities—refresh and drop
Policy utility activities such as refreshing or dropping can be done through DBMS_RLS package subprograms. Refreshing a policy pushes an enabled VPD protocol to inherit the latest changes done to the policy and its dependents. Policy refresh is required when the underlying referenced objects of the policy undergo changes. So as to invalidate its dependent objects operationally during the policy refresh process, all the cached statements associated with the policy are parsed again.
Notice that a disabled VPD policy cannot be refreshed.
The subprogram requires the policy owner, the table or view name, and the policy name as the input parameters:
SQL> EXEC DBMS_RLS.REFRESH_POLICY('ORADEV','EMPLOYEES','EMP_DEPT_20'); ...Get Oracle Advanced PL/SQL Developer Professional Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
