/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 votes222 views1 answer
Oracle sql drop column if exists
SQL
3 votes249 views1 answer
Make a field auto_increment mysql
SQL
1 vote269 views2 answers
Regex starts with
SQL
1 vote280 views1 answer
How to convert number to hours and minutes in oracle sql
SQL
0 vote268 views1 answer
Alter owner in PostgreSQL
SQL
0 vote269 views2 answers
How to use aggregate functions in sql
SQL
0 vote262 views1 answer
Sql change date format
SQL
0 vote299 views1 answer
Virtuoso sql query tutorial
SQL
3 votes264 views2 answers
Host is not allowed to connect to this mysql server
SQL
0 vote229 views1 answer
Print sum of values sql
SQL