1 2 3 4 5 6 7 8 9 |
SELECT os_username, userhost, TIMESTAMP, TERMINAL, returncode -- 0: normal, 1017: wrong user/pass, 28000: account locked. FROM DBA_AUDIT_TRAIL WHERE ACTION_NAME='LOGON' AND USERNAME ='OTM' --DB User ORDER BY TIMESTAMP DESC ; |