/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

0 vote117 views1 answer
Mysql error 1452
SQL
1 vote143 views1 answer
Postgres see sequence current state
SQL
0 vote158 views1 answer
Get first monday of month sql
SQL
0 vote157 views1 answer
ORACLE PARSE STRING
SQL
23 votes120 views6 answers
How to create table in sql
SQL
7 votes126 views6 answers
Nth highest salary in sql
SQL
1 vote119 views1 answer
Importance of comment in mysql
SQL
0 vote132 views1 answer
Copying query result to excel
SQL
0 vote125 views1 answer
Postgres data location
SQL
3 votes128 views1 answer
Sql server version query
SQL