/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

2 votes190 views3 answers
Mysql kill
SQL
0 vote185 views1 answer
Sqlcmd xml output insert line break after every 2033 characters
SQL
0 vote184 views1 answer
Hibernate show sql xml property
SQL
1 vote174 views1 answer
Table information in sql server
SQL
18 votes171 views2 answers
Sql inner join
SQL
0 vote166 views1 answer
Mysqldump don't drop table
SQL
0 vote201 views1 answer
Insufficient privileges while creating view in sql oracle
SQL
1 vote165 views1 answer
Oracle lowercase
SQL
8 votes194 views1 answer
Mysql dump restore
SQL
0 vote222 views1 answer
Pgadmin postgres ERROR: database is being accessed by other users
SQL