Skip to Main Content

Oracle Database Free

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!

Unable to Generate Specific Oracle Database Audit Event Codes in 23c

Zeel AjadiyaJul 15 2025

I am currently trying to generate several Oracle Database Audit Events, but I am unable to generate a few specific events.

I am attempting to generate events from the following categories:

  • Service and Application Utilization Events
  • Audit Command Events
  • Role and Privilege Management Events

Service and Application Utilization Events:
I am unable to generate event code 116 (EXECUTE PROCEDURE). I have tried creating and executing procedures in multiple ways, but in all cases, event code 47 (PL/SQL EXECUTE) is generated instead.

Audit Command Events:
I am unable to generate the following event codes:

  • 106 (AUDIT DEFAULT)
  • 107 (NOAUDIT DEFAULT)
  • 104 (SYSTEM AUDIT)
  • 105 (SYSTEM NOAUDIT)

When I attempt actions related to these events, the events that are generated fall under event codes 30 (AUDIT OBJECT) and 31 (NOAUDIT OBJECT) instead. I have also tried creating different audit policies for these events, but still have not had any success.

Role and Privilege Management Events:
I am unable to generate the following event codes:

  • 114 (GRANT ROLE)
  • 115 (REVOKE ROLE)
  • 502 (SET USER OR PROGRAM UNIT LABEL)
  • 505 (OBJECT EXISTS ERRORS)
  • 506 (PRIVILEGED ACTION)

For event codes 114 (GRANT ROLE) and 115 (REVOKE ROLE), I have attempted the relevant operations, but instead of these event codes, event code 17 (GRANT OBJECT) and event code 18 (REVOKE OBJECT) are being generated.

Comments
Post Details
Added on Jul 15 2025
2 comments
173 views