Database Security Products (MOSC)

MOSC Banner

How to get file-based auditing of logon/logoff in mixed mode

edited Nov 7, 2024 2:18PM in Database Security Products (MOSC) 2 commentsAnswered ✓

Hello,

I have been asked to enable logon and logoff auditing of regular users on a 19.14 database.
I need it to be file-based.

It's configured by default i.e. in mixed mode.
I have set:
audit_file_dest string /app/site/<SID>/base/adump
audit_sys_operations boolean FALSE
audit_syslog_level string
audit_trail string OS

The following traditional audit setting works OK:
SQL> audit session;
I do get the *.aud files in adump.

However if I try using the new style auditing after clearing the former setting by "noaudit session":

SQL> create audit policy connection_policy actions logon, logoff;

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