Oracle failed login attempts

-- 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 vote113 views1 answer
Sql server on mac m1
SQL
0 vote109 views1 answer
Access refused mysql xampp server
SQL
2 votes117 views1 answer
Rails execute sql
SQL
10 votes110 views3 answers
Join multiple tables sql
SQL
0 vote114 views1 answer
Create table sql generator
SQL
0 vote123 views1 answer
DATEDIFF minute postgres
SQL
0 vote128 views2 answers
Sql server set default value equal to auto increment
SQL
0 vote116 views1 answer
Convert uniqueidentifier to varchar in sql
SQL
5 votes118 views3 answers
Select tables from mysql database
SQL
12 votes105 views5 answers
Sql primary key
SQL