Code Snippet

Just another Code Snippet site

Oracle – Tracking failed logon attempts

enable audit :

audit create session whenever not successful;

Check audit result :

select 
   os_username,
   username,
   terminal,
   to_char(timestamp,'MM-DD-YYYY HH24:MI:SS')
from
   dba_audit_trail;

,


One thought on “Oracle – Tracking failed logon attempts

Leave a Reply

Your email address will not be published. Required fields are marked *