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 vote122 views1 answer
Sql server: difference between hashtable and table declared using declare keyword
SQL
0 vote116 views1 answer
Mysql find db contarint
SQL
2 votes120 views1 answer
Q operator in oracle
SQL
11 votes123 views3 answers
Python sqlite3 create table if not exists
SQL
0 vote117 views1 answer
Nvl2 syntax
SQL
1 vote125 views2 answers
Mysql trim spaces
SQL
2 votes104 views1 answer
Ifnull postgres
SQL
1 vote123 views1 answer
Change table to innodb mysql
SQL
7 votes133 views2 answers
Postgres concat
SQL
12 votes112 views3 answers
Install sqlite driver ubuntu
SQL