/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 vote179 views1 answer
Openquery insert into linked server
SQL
0 vote166 views1 answer
Select password from user mysql
SQL
1 vote186 views1 answer
Postgresql pass array in function
SQL
0 vote174 views1 answer
Sql row number in result set
SQL
0 vote184 views1 answer
Mysql workbench not showing schemas
SQL
0 vote171 views1 answer
TITLE: SQL Server principal "dbo" does not exist
SQL
0 vote201 views1 answer
See the structure of a table mysql
SQL
0 vote166 views1 answer
Postgresql import data from csv
SQL
0 vote181 views1 answer
VSCode SQL Server Connection error
SQL
0 vote206 views1 answer
T-sql update table variale
SQL