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

15 votes235 views4 answers
Export mysql db using command line
SQL
0 vote189 views1 answer
Difference between 2 query results sql server
SQL
14 votes175 views3 answers
Delete all records from table except sql
SQL
1 vote195 views1 answer
Print all records of table in mysql
SQL
21 votes184 views6 answers
Docker run mysql
SQL
2 votes168 views3 answers
Mysql unix timestamp to date
SQL
0 vote182 views1 answer
How to increase the width of the screen in oracle
SQL
1 vote205 views1 answer
T-sql disable system versioning
SQL
0 vote138 views1 answer
Procedures and functions in pl/sql
SQL
0 vote183 views1 answer
Mysql update even / odd rows
SQL