Database Security Products (MOSC)

MOSC Banner

Audit_Trail parameter's value is set to OS

edited Dec 21, 2018 11:18AM in Database Security Products (MOSC) 4 commentsAnswered

Hi gurus,

in our environment, audit related parameter are set to:

audit_sys_operations             boolean TRUE
audit_syslog_level               string  LOCAL6.DEBUG
audit_trail                      string  OS

rsyslog daemon is running and the audit file is written to "/var/log/local6.log" file.

I have executed the below command on my database for auditing some specific tasks.

audit insert, update, delete on scott.test_adg by session;

And do the insert, update, delete accordingly for testing the effect. The "local6.log" file is written the log file like following format. It does not showing me the statement i have executed.

:: insert ::

Tagged:

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