Database Administration (MOSC)

MOSC Banner

Audit/Track chnages made by system user in DB.

edited Sep 26, 2018 1:43AM in Database Administration (MOSC) 6 commentsAnswered ✓

Hi All,

We have team of DBA(Onsite/Offsite)  having sysdba privileges managing 11.2 and 12c DB on Linux 7 platform .

I have following setting for DB auditing .

------------------------------------ ----------- ------------------------------

audit_file_dest                      string      /u01/oracle/product/admin/SG0003P/adump

audit_sys_operations                 boolean     TRUE

audit_syslog_level                   string

audit_trail                          string      DB

unified_audit_sga_queue_size         integer     1048576

Is there any way we can track DB related parameter changed by any team member using  sys/system DB privileged  accounts ?

Thanks and Regards.

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