/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

0 vote121 views1 answer
Mysql convert column to uppercase
SQL
2 votes171 views2 answers
Mamp connect mysql terminal
SQL
2 votes180 views1 answer
Grant revoke privileges to mysql username
SQL
0 vote201 views1 answer
Sql select rows with different values in one column
SQL
53 votes554 views6 answers
How to install mysql ubuntu
SQL
0 vote170 views1 answer
Mssql check if date is greater than today
SQL
1 vote182 views1 answer
Oracle create index if not exists
SQL
38 votes249 views6 answers
Ubuntu install mysql client
SQL
2 votes197 views3 answers
Current setting postgres timezone
SQL
3 votes228 views1 answer
Oracle sql commit example
SQL