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

1 vote262 views1 answer
Oracle sql create view
SQL
0 vote246 views1 answer
Get first name and last name from full name string in SQL
SQL
0 vote294 views1 answer
Sqlite woth cmake
SQL
0 vote254 views1 answer
Check if table exists oracle
SQL
8 votes295 views1 answer
Oracle search stored procedures for text
SQL
4 votes305 views3 answers
Postgres drop all tables
SQL
9 votes282 views4 answers
How to alter table column name in mysql
SQL
0 vote280 views2 answers
Faster mysql imports
SQL
0 vote254 views1 answer
From _sqlite3 import * ImportError: DLL load failed: Das angegebene Modul wurde nicht gefunden.
SQL
1 vote275 views1 answer
Mysql event last execution
SQL