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

2 votes194 views2 answers
Sql first character
SQL
0 vote221 views2 answers
How to get max from each department in sql
SQL
0 vote219 views1 answer
How to get data from 2 database
SQL
3 votes205 views1 answer
V$session not found in oracle
SQL
1 vote269 views2 answers
Intersect sql
SQL
3 votes185 views3 answers
Concatenation in sql
SQL
1 vote181 views1 answer
Set id count mysql
SQL
0 vote201 views1 answer
Check if string is a number sql
SQL
0 vote193 views1 answer
SQL Server rename foreign key constraint
SQL
0 vote183 views1 answer
Sqlite3 now
SQL