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 vote208 views1 answer
Load data infile mariadb slow
SQL
0 vote221 views1 answer
Full outer join in mariadb mysql
SQL
0 vote195 views1 answer
Sum values by month mariadb
SQL
0 vote195 views1 answer
How to get data between a last week in mysql
SQL
17 votes214 views4 answers
Show tables sql server
SQL
0 vote196 views2 answers
Oracle sql for each row
SQL
2 votes190 views1 answer
Sqlite insert if not exists
SQL
1 vote187 views1 answer
Is sql fast
SQL
1 vote191 views1 answer
Mysql select update same table
SQL
8 votes152 views2 answers
Alter column name in mssql
SQL