Database Administration (MOSC)

MOSC Banner

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center