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

37 votes374 views3 answers
Sql check duplicate value in column
SQL
1 vote226 views1 answer
Load sql into mamp
SQL
0 vote233 views1 answer
Mysql config slave
SQL
1 vote387 views3 answers
Sql subquery
SQL
0 vote251 views1 answer
Migration graphql
SQL
5 votes227 views3 answers
Mysql update field from one table to another
SQL
0 vote235 views1 answer
Postgresql create user roles
SQL
3 votes244 views2 answers
Sql not contains
SQL
0 vote242 views1 answer
Distinct data types in a table sql query
SQL
2 votes233 views1 answer
How to find constraints on a table in oracle
SQL