/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 vote136 views1 answer
Sqlalchemy existing database
SQL
0 vote176 views1 answer
Sql python hwo to pass a list in paramerter
SQL
1 vote167 views3 answers
Error 1451 (23000): cannot delete or update a parent row: a foreign key constraint fails
SQL
0 vote156 views1 answer
Myswql show full processlist
SQL
0 vote252 views1 answer
Mysql select random rows large table
SQL
19 votes194 views1 answer
Sqrt(-1)
SQL
0 vote179 views1 answer
Psql check table fields
SQL
0 vote161 views1 answer
Downgrading sql localdb visual studio
SQL
2 votes169 views2 answers
Postgres trigger insert into another table
SQL
1 vote175 views1 answer
How to check the mysql version mac
SQL