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

0 vote173 views1 answer
Oracle list index on table
SQL
22 votes169 views3 answers
Join three tables sql
SQL
10 votes193 views4 answers
Mysql if else
SQL
0 vote204 views1 answer
Find how many tables in database sql query
SQL
0 vote188 views1 answer
Oracle concat datetime
SQL
0 vote172 views10 answers
John the ripper mysql
SQL
1 vote168 views1 answer
Mysql server does not start mac
SQL
0 vote175 views2 answers
Update Query in SQL Server Table - NAYCode.com
SQL
1 vote175 views1 answer
Primary key reset in SQL database
SQL
0 vote200 views1 answer
Virtuoso sql query tutorial
SQL