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 vote251 views1 answer
Automate mysql cli query
SQL
0 vote298 views1 answer
Postgresql inheritance
SQL
4 votes270 views2 answers
Bulk kill mysql processlist
SQL
-1 vote270 views3 answers
Error mysql shutdown unexpectedly
SQL
0 vote298 views1 answer
Sql statement show all emails with dome
SQL
0 vote268 views1 answer
Postgresql where clause not working
SQL
0 vote265 views1 answer
Select from another database
SQL
0 vote285 views2 answers
Mysql where in maintain order group_concat
SQL
1 vote269 views1 answer
Mysql get latest duplicate rows
SQL
17 votes274 views3 answers
Cast in sql server
SQL