/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

1 vote124 views1 answer
Order by oracle
SQL
4 votes139 views1 answer
W3schools create table
SQL
0 vote265 views1 answer
Sql change a colum to unique
SQL
0 vote132 views1 answer
View to table
SQL
0 vote146 views1 answer
Mysql utc timestamp
SQL
0 vote129 views1 answer
Snap craft
SQL
2 votes172 views1 answer
Select from array in psql
SQL
5 votes129 views3 answers
Mysql check if null or empty string
SQL
11 votes159 views6 answers
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
SQL
4 votes121 views1 answer
SQL order random
SQL