Database Security Products (MOSC)

MOSC Banner

ORA-01031: insufficient privileges not audited

Hi,
We have Oracle 19.12 running on Oracle Linux 7.
I am trying to find out why 'insufficient privileges' is not showing.
I am auditing 'audit insert any table'  The failure is not shown when I query 'DBA_COMMON_AUDIT_TRAIL '

My current settings:
SYS@DPPROD1> show parameters audit

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
audit_file_dest                      string      /u01/app/oracle/admin/DPPROD1/
                                                 adump
audit_sys_operations                 boolean     FALSE
audit_syslog_level                   string
audit_trail                          string      XML, EXTENDED
unified_audit_common_systemlog       string
unified_audit_sga_queue_size         integer     1048576
unified_audit_systemlog              string
SYS@DPPROD1>

Thanks,

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