/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 vote177 views1 answer
Mysql date + 1 day
SQL
0 vote193 views1 answer
Get first name and last name from full name string in SQL
SQL
1 vote205 views1 answer
Get all db sizes in mysql server
SQL
0 vote213 views1 answer
Doesn't have default value mysql
SQL
2 votes188 views1 answer
Convert series number to date in sql
SQL
1 vote229 views1 answer
Mariadb get column names from table
SQL
0 vote219 views1 answer
Postgresql delete limit
SQL
0 vote193 views1 answer
Get duplicate entry sql
SQL
1 vote276 views2 answers
Coderbyte sql solutions
SQL
1 vote169 views1 answer
Mssql string length
SQL