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

1 vote258 views1 answer
Mysql month name extract
SQL
0 vote242 views1 answer
How to update random rows in sql
SQL
1 vote240 views1 answer
Function difference_in_hours(timestamp with time zone) does not exist
SQL
0 vote262 views3 answers
Database restoring error
SQL
2 votes267 views1 answer
When matched in sql server
SQL
20 votes252 views2 answers
Counting in sql
SQL
0 vote247 views1 answer
Get last updated row sql server
SQL
0 vote261 views1 answer
Mariadb select limit offset
SQL
0 vote242 views1 answer
Min salary in sql
SQL
0 vote298 views1 answer
Mariadb.service failed with result 'exit-code'
SQL