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 vote305 views1 answer
Get first match in each group mysql query
SQL
6 votes130 views1 answer
Phpmyadmin reset root password
SQL
0 vote148 views1 answer
ACCEPT nome PROMPT on oracle
SQL
2 votes136 views3 answers
How to pass password mysql command line
SQL
0 vote159 views1 answer
Arithmetic expression in sql
SQL
0 vote158 views1 answer
Full outer join in mariadb mysql
SQL
0 vote140 views1 answer
Move table to a different schema
SQL
23 votes145 views4 answers
How to uninstall postgresql in ubuntu
SQL
1 vote145 views1 answer
Mysql last year
SQL
0 vote143 views1 answer
Copy data from one postgres container to another
SQL