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 vote302 views1 answer
Sql script to get a type task on jira datbase for 12 months
SQL
5 votes316 views2 answers
Postgresql add not null constraint
SQL
1 vote302 views1 answer
Sql server cast date dd/mm/yyyy
SQL
3 votes284 views1 answer
How to remove characters from string in mysql
SQL
2 votes342 views1 answer
Drop all foreign key constraints mysql
SQL
1 vote306 views1 answer
Expression number 1 of select list is not in group by clause
SQL
79 votes561 views6 answers
Grepper code
SQL
1 vote320 views1 answer
Second last highest id in sql
SQL
0 vote315 views1 answer
Databricks install odbc driver connect to sql server
SQL
0 vote287 views1 answer
Aktor yang pernah terlibat di film bergenre Aksi di sql
SQL