/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

8 votes292 views2 answers
Mysql get first x characters
SQL
1 vote270 views2 answers
Sql select only row with the max date
SQL
-1 vote283 views1 answer
Capitole toulouse
SQL
0 vote360 views1 answer
How to rename a database in tsql
SQL
0 vote307 views1 answer
Insert value in identity
SQL
4 votes270 views3 answers
Mysql varchar length
SQL
11 votes253 views2 answers
Sql between date range
SQL
0 vote268 views1 answer
Price-colour
SQL
4 votes287 views1 answer
Mysql copy table with new name
SQL
0 vote278 views1 answer
Replace string in whole database mysql stackoverflow
SQL