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

5 votes352 views1 answer
Oracle nls session
SQL
1 vote350 views3 answers
Postgresql get difference between two dates
SQL
-1 vote325 views1 answer
Mysql change database charset and collation
SQL
0 vote302 views1 answer
Generate sequence number in sql server
SQL
20 votes353 views6 answers
Change password in mysql
SQL
5 votes322 views1 answer
Find table from column name in sql
SQL
0 vote303 views1 answer
Lister les index d'une table oracle
SQL
0 vote327 views1 answer
Permission denied postgres \copy csv command line
SQL
1 vote316 views1 answer
PLS-00225 type
SQL
0 vote312 views1 answer
Mysql auto increment in YY-MM-XXX format
SQL