I created alert policy as shown in below screenshot. When I do create
or drop
statement it is not showing alerts of the condition. I don't know where the problem is
Steps:
Created custom audit policy in db:
CREATE AUDIT POLICY TABLE_MANAGEMENT_POLICY
ACTIONS CREATE TABLE, DROP TABLE;
Enabled it:
AUDIT POLICY TABLE_MANAGEMENT_POLICY;
In the avdf create audit policy and alert condition:
:EVENT_NAME IN ('CREATE', 'ALTER', 'DROP')
AND :TARGET_TYPE IN ('TABLE', 'INDEX', 'VIEW', 'SEQUENCE',
'PROCEDURE')
But when do create
statement in db, it is not showing alert in avdf console. Screenshot:
Unable to get the alert. Trying to fix it, can any one help with it?