/SQL/Oracle list invalid password logon denied

Oracle list invalid password logon denied

-- 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

10 votes198 views1 answer
Query to find object dependencies in oracle
SQL
0 vote212 views3 answers
Postgres date difference seconds
SQL
0 vote195 views1 answer
On update current_timestamp jpa
SQL
1 vote205 views1 answer
Oracle create program if no exists
SQL
0 vote195 views1 answer
Drop a field in psql django
SQL
0 vote213 views2 answers
How to Alter column in SQL Server - NAYCode.com
SQL
3 votes215 views4 answers
Postgresql change timezone on timestamp without timezone
SQL
0 vote239 views1 answer
Kimball data warehouse sql calendar
SQL
0 vote185 views1 answer
Oracle synonym procedure
SQL
1 vote197 views1 answer
Date_part mysql
SQL