As an example, the audit information may look like the following:
ALTER SESSION SET NLS_DATE_FORMAT='DD.MM.YYYY HH24:MI:SS';
SELECT os_username, userhost, timestamp, returncode FROM dba_audit_session WHERE action_name = 'LOGON' AND returncode > 0 AND trunc(timestamp) = to_date('08.07.2013', 'DD.MM.YYYY') AND username = 'TSF' ORDER BY timestamp DESC;
Result:
OS_USERNAME USERHOST TIMESTAMP RETURNCODE ----------- ----------- ------------------- ---------- billyb CHM06071130 08.07.2013 12:24:07 1017 billyb CHM06071130 08.07.2013 10:06:06 28000You can use the sqlerrm keyword to print the meaning of a return code, like this:
exec dbms_output.put_line(sqlerrm(-1017)) ; exec dbms_output.put_line(sqlerrm(-28000)) ;These commands will yield:
ORA-01017: invalid username/password; logon denied ORA-28000: the account is locked
No comments:
Post a Comment