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

3 votes200 views1 answer
Dbms_scheduler drop_job
SQL
0 vote154 views4 answers
Postgresql between month
SQL
1 vote174 views2 answers
Limit sqlserver
SQL
0 vote184 views2 answers
Create more than 1 tables with references to each other in sqlite3
SQL
0 vote162 views1 answer
Sql revert migration
SQL
2 votes188 views2 answers
Asp.net core with postgresql deploy on ubuntu
SQL
3 votes186 views1 answer
Mysql cli connect with password
SQL
1 vote242 views1 answer
Python clean sql string
SQL
0 vote150 views1 answer
How to select only a certain date sql
SQL
0 vote160 views1 answer
Oracle table free space
SQL