/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

0 vote209 views2 answers
Call to undefined function mysql_query()
SQL
0 vote205 views1 answer
How to import pymysql through jupyter notebook for windows
SQL
5 votes236 views1 answer
Oracle ora-00054 resource busy
SQL
0 vote196 views1 answer
Populate db from command line postgres
SQL
0 vote188 views1 answer
Normalization in database
SQL
0 vote179 views1 answer
Mysql workbench format date
SQL
0 vote205 views1 answer
EnvironmentError: mysql_config not found
SQL
21 votes195 views4 answers
Oracle add column
SQL
0 vote234 views1 answer
Execute a stored procedure in another stored procedure in SQL server
SQL
19 votes231 views1 answer
Sqrt(-1)
SQL