/SQL/Oracle list invalid password logon denied

Oracle list invalid password logon denied

-- Detects invalid password fails (ORA-01017)
SELECT username,
       os_username,
       userhost,
       client_id,
       trunc(timestamp),
       count(*) as failed_logins
FROM dba_audit_trail
WHERE returncode = 1017
  AND --1017 is invalid username/password
    timestamp > sysdate - 30
GROUP BY username, os_username, userhost, client_id, trunc(timestamp);

Similar codes

5 votes171 views2 answers
Create table mysql example auto_increment
SQL
0 vote148 views1 answer
Vbscript create ADODB.Connection
SQL
3 votes148 views1 answer
APEX elapsed time
SQL
0 vote166 views1 answer
Sqlite explain plan
SQL
2 votes163 views1 answer
11:04:35 PM [mysql] Error: MySQL shutdown unexpectedly.
SQL
18 votes156 views6 answers
Create table mysql
SQL
0 vote180 views1 answer
Insert value in identity
SQL
0 vote150 views2 answers
Update all linkedserver tables with openquery on db
SQL
0 vote152 views1 answer
T-sql email validation
SQL
1 vote150 views1 answer
Show table columns
SQL