Can you create an INSTEAD OF trigger on a v$ view?
Hello,
I'm interested in auditing the v$vpd_policy SYS view. I understand I cannot create a trigger on a view directly, but I can create an INSTEAD OF trigger and perhaps dump the valued information into a separate table. I am getting ORA-00942: table or view does not exist errors when I try to compile my view, highlighting v$vpd_policy as the offender:
CREATE OR REPLACE TRIGGER MY_VPD_AUD INSTEAD OF INSERT ON v$vpd_policy FOR EACH ROW ...
I also tried specifying it as v_$vpd_policy. Are SYS views excluded from being eligible for this type of trigger? Is there something else out there that would enable me to capture this information? I am interested in auditing the v$vpd_policy view pulling supporting data from v$sql and v$sql_monitor so I can validate that the policy is being applied as expected for a specific application. Any advice is appreciated.