User Tools

Site Tools


databaseauditing

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
databaseauditing [2015/10/21 10:18] – external edit 127.0.0.1databaseauditing [2025/03/08 22:24] (current) – external edit 127.0.0.1
Line 25: Line 25:
 <code>alter session set nls_date_format = 'DD-MON-YYYY HH24:MI'; <code>alter session set nls_date_format = 'DD-MON-YYYY HH24:MI';
 set linesize 160 set linesize 160
-col os_username format a20 +col os_username format a15 
-col userhost format a25+col userhost format a45
  
-select os_username, username, action, userhost, timestamp +select os_username, username, returncode, userhost, timestamp 
 from dba_audit_trail  from dba_audit_trail 
 where timestamp > trunc(sysdate) where timestamp > trunc(sysdate)
databaseauditing.1445422735.txt.gz · Last modified: 2025/03/08 22:23 (external edit)