/SQL/Oracle list invalid password ORA-01017

Oracle list invalid password ORA-01017

-- 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

25 votes170 views6 answers
How to change column name in mysql
SQL
0 vote149 views1 answer
Codeigniter dbforge add index
SQL
1 vote161 views1 answer
Oracle insert multiple rows into same table
SQL
3 votes149 views1 answer
How to find names includes in sql
SQL
0 vote145 views1 answer
Alasql delete column
SQL
0 vote147 views1 answer
Sql create table with datetime automatically
SQL
0 vote210 views1 answer
Check user sql password from command line
SQL
3 votes139 views2 answers
Laravel tosql with bindings
SQL
0 vote150 views1 answer
Mysql_union
SQL
1 vote136 views1 answer
Sql convert month name to number
SQL