/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 vote288 views1 answer
View to table
SQL
1 vote323 views2 answers
Mysql limit offset
SQL
0 vote312 views1 answer
Sql get year from datetime field
SQL
0 vote298 views1 answer
List column names of multiple tables psql
SQL
0 vote316 views1 answer
The fetch keyword oracle
SQL
-1 vote322 views1 answer
Search all sql tables for a value
SQL
103 votes507 views1 answer
Like sql
SQL
3 votes319 views5 answers
Duplicate table sql
SQL
4 votes298 views2 answers
Mysql delete user if exists
SQL
0 vote304 views1 answer
List all permissions on a table in postgres
SQL