DOYENSYS Knowledge Portal

We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal

Tuesday, June 28, 2016

To get the details of audit records for user sessions

select os_username "O/S User",        /*Operating system username used.*/
username "User",               /*Oracle username of the account used.*/
terminal "Terminal",           /*Terminal ID used.*/
'1017','Failed',returncode) "Status",         /*Failure check*/
to_char(timestamp,'DD-MON-YY HH24:MI:SS') "Login",    /*Login time*/
to_char(logoff_time,'DD-MON-YY HH24:MI:SS') "Logoff"  /*Logoff time*/
from dba_audit_session;

No comments: