/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

1 vote151 views1 answer
Default
SQL
0 vote147 views1 answer
Select all columns except one sql
SQL
34 votes131 views5 answers
Oracle alter table add column
SQL
0 vote146 views1 answer
Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'autos_id' in 'field list' in
SQL
0 vote82 views1 answer
FindAllBy
SQL
3 votes154 views1 answer
Oracle apex message quit website
SQL
1 vote165 views1 answer
Select not matching data with join table
SQL
0 vote138 views2 answers
Mysql update two tables at once
SQL
5 votes131 views1 answer
List foreign key oracle
SQL
16 votes162 views6 answers
Python sqlite
SQL