Oracle detect invalid password

-- 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 vote318 views1 answer
Select row from mysql where date more than 30 days
SQL
1 vote355 views1 answer
Postgresql escape single quote
SQL
0 vote339 views1 answer
No suitable driver found for sqlite
SQL
1 vote329 views2 answers
Replace text in sql
SQL
5 votes332 views1 answer
Pl sql asynchronous procedure calls
SQL
0 vote313 views1 answer
Get all employees if name ends with in sql
SQL
0 vote314 views1 answer
Version and edition of SQL Server Database Engine
SQL
0 vote329 views1 answer
Mysql add to value
SQL
0 vote329 views2 answers
What is 1=2 in sql
SQL
0 vote428 views1 answer
Mysql get nested records
SQL