creating alert policies in oracle audit vault and database firewall - Stack Overflow

admin2025-04-17  2

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:

  1. Created custom audit policy in db:

     CREATE AUDIT POLICY TABLE_MANAGEMENT_POLICY 
    ACTIONS CREATE TABLE, DROP TABLE;
    
  2. Enabled it:

    AUDIT POLICY TABLE_MANAGEMENT_POLICY;
    
  3. 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?

转载请注明原文地址:http://anycun.com/QandA/1744836890a88304.html