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

-2 votes164 views3 answers
Oracle tablespace usage
SQL
1 vote189 views2 answers
Oracle leftmost characters
SQL
0 vote152 views1 answer
Alter table add foreign key mariadb example
SQL
4 votes165 views2 answers
Sql table
SQL
1 vote187 views1 answer
Postgres see sequence current state
SQL
1 vote344 views2 answers
Sql unique rows
SQL
18 votes198 views2 answers
Find all tables containing column with specified name - MS SQL Server
SQL
0 vote210 views1 answer
Manage Database in MySQL
SQL
0 vote192 views1 answer
MySQL import data from large CSV file
SQL
16 votes213 views6 answers
Insert sql
SQL