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.