Database Administration (MOSC)

MOSC Banner

DBA_AUDIT_TRAIL observation, part duex

edited Apr 25, 2019 4:16PM in Database Administration (MOSC) 1 comment

Oracle 12.1.0.2 SE-2

Another curious observation while looking at something else ...

select        userhost,       os_username os_user,       regexp_replace(comment_text,'([\;])', '\1'||chr(10)||chr(13)) as comment_text,       priv_used,       timestampfrom dba_audit_trailwhere action=100  and username='SYSTEM'  and returncode=0order by userhost,       os_username,       comment_text,       priv_used,       timestamp; USERHOST                  OS_USER    COMMENT_TEXT                                                                PRIV_USED       TIMESTAMP------------------------- ---------- --------------------------------------------------------------------------- --------------- --------------------MYDM\ESTEVEN              esteven    Authenticated by: DATABASE;                                                 CREATE SESSION  17-MAY-2018 15:02:23                                       Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=***.**.*.11)(PORT=50086))devserv.myorgname.org     oracle     Authenticated by: DATABASE;                                                 CREATE SESSION  20-JAN-2019 11:00:01                                       Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=***.**.*.20)(PORT=12185))devserv.myorgname.org     oracle     Authenticated by: DATABASE;                                                 CREATE SESSION  23-AUG-2018 14:43:11

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