Oracle detect invalid password

-- 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

4 votes382 views2 answers
Postgresql float data type
SQL
0 vote343 views1 answer
T sql dynamic top n query
SQL
0 vote330 views1 answer
How to execute stored output to csv files
SQL
0 vote290 views1 answer
Requete sql mise a jour content dans un colone mysql
SQL
1 vote343 views1 answer
Postgres power
SQL
0 vote338 views1 answer
Create database like
SQL
0 vote308 views1 answer
Sqlalchemy.exc.DBAPIError: (ibm_db_dbi.Error) ibm_db_dbi::Error: SystemError('<built-in function connect> returned NULL without setting an error')
SQL
0 vote406 views1 answer
Intellij mysql set timezone
SQL
0 vote346 views1 answer
Mysql search like but first exact match
SQL
0 vote406 views1 answer
ORA-32794: cannot drop a system-generated sequence
SQL