Database Administration (MOSC)

MOSC Banner

Querying cdb_scheduler_jobs generates audit

edited Sep 29, 2023 1:42PM in Database Administration (MOSC) 4 commentsAnswered

Hi,

db version: 19.20 on RHEL 7.9

I realized that one of my databases has too much audit records. I have a common user on the CDB. This user is granted DBA and some more privileges. User has a job which calls a procedure and queries cdb_scheduler_jobs in it. interestingly, every select on cdb_scheduler_jobs in the job generates audit records. if I run a select statement against cdb_scheduler_jobs it does not generate audit but if I run the procedure, then it does generate audit records.

unified audit is on and traditional audit is off on the database. ORA_LOGON_FAILURES and ORA_SECURECONFIG are only enabled audit policies.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center