Database Security Products (MOSC)

MOSC Banner

Audit schema (user app) in oracle database

Dear Sir/Madam
I want to ask about audit schema (user app) in oracle database version 19c:

  • I audit user schema insert/update data on table of database
  • Performer action activity on web or application like create new data / change information on level Web or Application.

Question

  1. Does log in table (dba_audit_trail or SYS.AUD$) record those action?

Database option:

Version:19.22…
SHOW PARAMETER AUDIT
—-

audit_file_dest string /u01/app/oracle/admin/DBname/adump
audit_sys_operations boolean TRUE
audit_syslog_level string
audit_trail string DB, EXTENDED
unified_audit_common_systemlog string
unified_audit_sga_queue_size integer 1048576

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