/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 vote150 views1 answer
Postgresql if else endif
SQL
0 vote166 views1 answer
Permission denied postgres \copy csv command line
SQL
0 vote141 views1 answer
Mysql to get column name in database
SQL
0 vote291 views2 answers
Https://cloud.google.com/shell/docs/using-web-preview#previewing_the_application
SQL
-1 vote136 views1 answer
Search all database tables for a value sqlserver
SQL
1 vote101 views1 answer
Postgres division by zero
SQL
2 votes144 views2 answers
Mysql bidirectional composite primary key
SQL
0 vote138 views1 answer
Postgresql isnull with max
SQL
1 vote146 views1 answer
Sql server list locks
SQL
16 votes161 views6 answers
Your connection attempt failed for user 'root' to the mysql server at localhost 3306
SQL