/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

3 votes149 views1 answer
Oracle cannot access v$session
SQL
0 vote133 views1 answer
Execut sql python
SQL
3 votes136 views2 answers
Mysql time
SQL
11 votes132 views3 answers
How to get last row of table in sql
SQL
5 votes126 views1 answer
Ora-00054 find lock
SQL
3 votes160 views2 answers
Synonym oracle
SQL
0 vote152 views1 answer
SQL Server date literal
SQL
7 votes117 views1 answer
Safe mode mysql
SQL
2 votes153 views1 answer
Oracle apex who is connected
SQL
1 vote183 views1 answer
Select last row from SQL Table
SQL