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

11 votes133 views2 answers
Having in sql
SQL
0 vote129 views1 answer
Add column not null with default value postgres
SQL
0 vote152 views2 answers
Install phoenix
SQL
0 vote117 views1 answer
Mysql regex exact match
SQL
0 vote138 views1 answer
Manage Database in MySQL
SQL
0 vote136 views1 answer
How to user id to show in from date to upto date in mssql server
SQL
2 votes134 views1 answer
SQLSTATE[HY000] [1049] Unknown database
SQL
0 vote121 views1 answer
Mysql case when on date
SQL
0 vote126 views1 answer
Create schema sql server
SQL
3 votes136 views2 answers
Syntax error or access violation: 1701 Cannot truncate a table referenced in a foreign key constraint
SQL