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

49 votes203 views6 answers
Alter table add column
SQL
0 vote138 views1 answer
Sql query for getting data with join and count
SQL
0 vote156 views1 answer
User, group, or role 'open' already exists in the current database.
SQL
1 vote160 views1 answer
Sql and
SQL
0 vote127 views1 answer
Java input type sql date
SQL
0 vote138 views1 answer
Cartesian product sql
SQL
0 vote132 views1 answer
SQLite3::SQLException: table "categories" already exists: CREATE TABLE "categories" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL
SQL
0 vote153 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception: syntax error in sql statement
SQL
23 votes144 views6 answers
Create table sql server
SQL
0 vote145 views1 answer
Sql server beginning of month
SQL