/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 vote357 views1 answer
VSCode SQL Server Connection error
SQL
5 votes386 views1 answer
Mysql add user with all privileges
SQL
2 votes356 views1 answer
Laravel sql String
SQL
0 vote355 views1 answer
Oracle change password expiration policy
SQL
1 vote399 views2 answers
Intersect sql
SQL
0 vote373 views1 answer
Capabilities of sql select statements
SQL
0 vote367 views1 answer
Java mysql swing example
SQL
1 vote356 views1 answer
Use of now() in mysql
SQL
0 vote350 views1 answer
To change the database owner in SQL server
SQL
0 vote399 views2 answers
Identity syntax in sql
SQL