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 vote349 views2 answers
Rebuild index sql server
SQL
0 vote340 views2 answers
Reduce size of SQL server log file truncate - Source :NAYCode.com
SQL
0 vote327 views1 answer
Sql select column names starting with
SQL
20 votes378 views1 answer
Get all table name in sql through php
SQL
0 vote386 views2 answers
Impala rename column name
SQL
2 votes364 views3 answers
Sql truncate table
SQL
0 vote362 views1 answer
C# get sql min date
SQL
0 vote345 views1 answer
Select last N rows mysql
SQL
0 vote394 views1 answer
Implode in sql query
SQL
1 vote347 views1 answer
How to check the mysql version mac
SQL