/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

1 vote119 views1 answer
Default
SQL
0 vote109 views1 answer
How to count null values in sql
SQL
0 vote126 views1 answer
Sqlite insert or update
SQL
3 votes116 views1 answer
Ms sql skip take
SQL
4 votes123 views1 answer
Mysql biginteger size
SQL
1 vote124 views1 answer
Multiple count in sql
SQL
0 vote100 views1 answer
Possgress drop if exists view
SQL
0 vote115 views1 answer
Mysql could not fetch tables
SQL
-1 vote130 views3 answers
SQL MM/dd/yyyy format
SQL
0 vote131 views1 answer
Print mysql
SQL