/SQL/Oracle list invalid password ORA-01017

Oracle list invalid password ORA-01017

-- 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 vote132 views1 answer
Ms sql print more than 1 variable
SQL
1 vote231 views3 answers
Nth highest salary
SQL
2 votes177 views2 answers
Mysql on duplicate key ignore
SQL
1 vote177 views3 answers
How to filter repeated same result using sql query
SQL
0 vote173 views3 answers
Sql count condition
SQL
0 vote233 views1 answer
Zsh: command not found: mysql mamp
SQL
0 vote179 views1 answer
Create_engine sqlalchemy with parsed url sql server
SQL
3 votes263 views4 answers
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client vs code
SQL
0 vote212 views1 answer
Stratified sampling sql
SQL
10 votes135 views2 answers
Django mysql
SQL