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 vote211 views1 answer
Do you know sql
SQL
1 vote164 views2 answers
Sql multiline comment
SQL
0 vote164 views1 answer
Sql get year from datetime field
SQL
0 vote166 views1 answer
Least spark sql
SQL
3 votes183 views1 answer
RENAME table pl sql
SQL
10 votes142 views5 answers
Mysql create user
SQL
21 votes188 views3 answers
Average sql
SQL
5 votes160 views2 answers
Create function postgresql
SQL
16 votes155 views3 answers
Update table from another table
SQL
1 vote149 views2 answers
Postgres copy table from one schema to another
SQL