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 vote182 views1 answer
Add plugins to mysql workbench
SQL
0 vote196 views1 answer
Mysql get first 2 characters of string
SQL
0 vote168 views1 answer
Create bakupd database sqlserver
SQL
1 vote186 views3 answers
Remove unique key from a table
SQL
0 vote213 views1 answer
In query in sql
SQL
3 votes185 views1 answer
Select nextval from sequence sql
SQL
0 vote192 views2 answers
Call to undefined function mysqli_fetch_all()
SQL
8 votes198 views1 answer
Show mysql user table
SQL
0 vote222 views1 answer
Group by max date
SQL
1 vote204 views1 answer
Spark sql convert string to date
SQL