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
- 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