/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 vote174 views1 answer
Sqlite version check
SQL
0 vote157 views1 answer
Mysql workbench primary key
SQL
0 vote160 views1 answer
Drop unique
SQL
3 votes159 views1 answer
Sql double index
SQL
4 votes170 views1 answer
Is there any command to change postgres password
SQL
0 vote144 views1 answer
Postgresql parse json array
SQL
1 vote169 views1 answer
Select inside insert query
SQL
0 vote173 views1 answer
Sql log file inof
SQL
0 vote160 views1 answer
Alter fedora mysql 8.0 user
SQL
0 vote182 views1 answer
Error Code: 1267. Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '=' 0.000 sec
SQL