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 vote260 views1 answer
Sql random decimal
SQL
7 votes278 views3 answers
Sql get last inserted row
SQL
0 vote278 views1 answer
Heidisql check how much space a row
SQL
0 vote299 views1 answer
Mariadb search columns
SQL
0 vote285 views1 answer
Convert int to varchar sql
SQL
0 vote291 views1 answer
Sql server concat null
SQL
0 vote300 views1 answer
On delete set default
SQL
6 votes278 views2 answers
Mysql check auto increment value
SQL
5 votes286 views2 answers
Oracle rename table
SQL
1 vote240 views1 answer
Postgres division by zero
SQL