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

2 votes296 views1 answer
Oracle index size
SQL
3 votes306 views1 answer
Mysql set field unique
SQL
0 vote285 views1 answer
SQL Server format datetime
SQL
11 votes340 views2 answers
Oracle source code
SQL
3 votes330 views2 answers
How to delete git repo locally
SQL
0 vote291 views1 answer
First mysql
SQL
0 vote306 views1 answer
Sql case sttement with set
SQL
0 vote295 views1 answer
Postgres full text search example
SQL
0 vote284 views1 answer
Sql comparison operators
SQL
2 votes343 views2 answers
Mysql bidirectional composite primary key
SQL