/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

1 vote122 views2 answers
ImportError: No module named mysql.connector
SQL
2 votes122 views1 answer
Oracle drop table free up space
SQL
0 vote130 views1 answer
Extract sql from query object sqlalchemy
SQL
2 votes119 views2 answers
Oracle no data found error code
SQL
2 votes177 views1 answer
Oracle trace session
SQL
0 vote119 views2 answers
Android sqlite tutorial for beginners
SQL
1 vote73 views1 answer
Postgres reset auto increment
SQL
0 vote122 views1 answer
What alter does in db
SQL
0 vote125 views1 answer
Normalization in database 2nd normal form
SQL
1 vote121 views2 answers
Install mysqldump ubuntu
SQL