Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

I have some problems with logging execute action in unified audit.

Hi all !

I want to enable dbms_scheduler audit, especially enable and disable procedures.

Unified aditing already enabled and works with another policies.

I just ran next test :

CREATE AUDIT POLICY SCHEDULER_AUDIT_POLICY
 ACTIONS
 execute ON dbms_scheduler ;
Done

AUDIT POLICY scheduler_audit_policy;
Audit succeeded

SELECT * FROM audit_unified_enabled_policies p where p.POLICY_NAME = 'SCHEDULER_AUDIT_POLICY';
POLICY_NAME                                                                      ENABLED_OPTION  ENTITY_NAME                                                                      ENTITY_TYPE SUCCESS FAILURE
-------------------------------------------------------------------------------- --------------- -------------------------------------------------------------------------------- ----------- ------- -------
SCHEDULER_AUDIT_POLICY                                                           BY USER         ALL USERS                                                                        USER        YES     YES

begin
 dbms_scheduler.enable(name => 'USER1.JOB_test' );
   dbms_scheduler.disable (name => 'USER1.JOB_test' );
END ;
/
PL/SQL procedure successfully completed

select count(1) as f1
 from audsys.aud$unified a
where a.event_timestamp > sysdate - 1/24
  and a.unified_audit_policies = 'SCHEDULER_AUDIT_POLICY';
       F1
----------
        0

Pls help, I have no clue where is the problem( Why dbms_scheduler.enable/disable executions haven't logged ? I tried reconnecting , and repeat call to dbms_scheduler, but still no any records.

Comments
Post Details
Added on Feb 5 2025
0 comments
54 views