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 vote316 views1 answer
Postgres get month name from date
SQL
0 vote366 views1 answer
What is metadata in sql
SQL
0 vote260 views1 answer
Check id exist or not in sql
SQL
0 vote396 views1 answer
Mysql get nested records
SQL
0 vote346 views1 answer
Mysql url
SQL
0 vote319 views2 answers
Tsql row number
SQL
1 vote306 views1 answer
User privileges postgresql information_schema
SQL
0 vote353 views1 answer
Mysql average from two table
SQL
4 votes305 views1 answer
Delete record mysql query
SQL
2 votes306 views1 answer
Date_format for time sql
SQL