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 vote115 views1 answer
R rmysql connect local database Plugin caching_sha2_password could not be loaded
SQL
0 vote164 views1 answer
Add week ending date sql server
SQL
7 votes121 views4 answers
Lowest salary in sql
SQL
0 vote134 views1 answer
Cartesian product sql
SQL
7 votes108 views1 answer
Mysql unsafe update
SQL
0 vote114 views1 answer
Postgresql array to rows
SQL
0 vote80 views1 answer
Update set with join pl sql
SQL
0 vote112 views1 answer
Sql server union if table exist
SQL
0 vote103 views1 answer
Sql examples from your work
SQL
4 votes133 views2 answers
Oracle unlock account
SQL