/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 vote239 views2 answers
Wordpress change url in database
SQL
6 votes256 views2 answers
Mysqldump password in file
SQL
1 vote234 views1 answer
Add time to date sql
SQL
4 votes219 views1 answer
SQL order random
SQL
0 vote233 views1 answer
Sql case when exists in another table
SQL
1 vote227 views1 answer
How to make a select in sql
SQL
0 vote232 views1 answer
Mysql two joins
SQL
5 votes242 views2 answers
Oracle apex debug mode
SQL
6 votes257 views2 answers
Mysql timestamp to date
SQL
0 vote251 views1 answer
How to add mysql to path on termin after installation
SQL