/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

1 vote128 views1 answer
Host 127.0 0.1 is not allowed to connect to this mysql server
SQL
1 vote121 views1 answer
Sql bitwise operators
SQL
16 votes124 views2 answers
Sql exists
SQL
2 votes141 views2 answers
Checking data type in sql server
SQL
0 vote124 views1 answer
Start and stop mysql
SQL
2 votes123 views1 answer
Mysql select random id from table
SQL
0 vote136 views1 answer
C# execute transact sql
SQL
2 votes118 views1 answer
Ssh mysql port forwarding
SQL
0 vote112 views1 answer
Insert thai language sql server
SQL
0 vote115 views1 answer
Sql date between one week
SQL