/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 vote115 views1 answer
List in one column mysql
SQL
0 vote108 views1 answer
Mariadb errno 121
SQL
0 vote115 views1 answer
Sql find gaps in date ranges
SQL
1 vote113 views1 answer
Mysql text to decimal
SQL
0 vote113 views1 answer
Mysql multiple primary keys
SQL
1 vote114 views1 answer
Sql select table header
SQL
0 vote103 views1 answer
Postgresql isnull with max
SQL
1 vote104 views1 answer
Sql delete row with auto increment
SQL
0 vote108 views2 answers
Postgres having
SQL
0 vote110 views1 answer
Sql server alter table column nullable
SQL