/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 vote218 views1 answer
How to connect to mysql in ef 6
SQL
0 vote227 views1 answer
Test connection to sql server
SQL
1 vote239 views1 answer
Sql view where tables have same column name combine results
SQL
0 vote216 views1 answer
Sql count * vs count 1
SQL
8 votes239 views3 answers
SQL column name
SQL
1 vote244 views1 answer
Store select query result in variable sql server
SQL
0 vote227 views2 answers
How to combine diff colmun value using group by postgres
SQL
0 vote239 views1 answer
WHERE not regex in SQL
SQL
0 vote221 views1 answer
Execute a stored procedure in another stored procedure in SQL server
SQL
0 vote225 views1 answer
Console output pl sql
SQL