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 votes219 views1 answer
Id increment ms sql server
SQL
0 vote209 views1 answer
Mysql show foreign keys column
SQL
0 vote239 views1 answer
Trigger vérifier stock
SQL
1 vote215 views2 answers
Postgresql get difference in hours between two dates
SQL
2 votes212 views1 answer
Codeigniter print last sql query
SQL
1 vote231 views1 answer
Oracle select row max date
SQL
6 votes240 views1 answer
How to get the size of the database in postgresql
SQL
0 vote195 views1 answer
Sql min
SQL
1 vote223 views1 answer
Postgres convert date to string
SQL
0 vote213 views1 answer
Select last N rows mysql
SQL