/SQL/Oracle list invalid password logon denied

Oracle list invalid password logon denied

-- 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

6 votes180 views1 answer
How to get the size of the database in postgresql
SQL
1 vote184 views3 answers
Alter schema sql server
SQL
0 vote177 views1 answer
Oracle current date minus 1 day
SQL
0 vote164 views2 answers
Mysql insert into multiple tables
SQL
4 votes137 views1 answer
Sql group by year
SQL
0 vote108 views2 answers
Jupyter notebook connect to database
SQL
1 vote148 views1 answer
Caused by: java.lang.IllegalStateException: Cannot load driver class: com.mysql.jdbc.Driver
SQL
0 vote150 views2 answers
T sql null or empty string
SQL
0 vote145 views1 answer
Mysql to get column name in database
SQL
1 vote152 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception table not found
SQL