/SQL/Oracle list invalid password ORA-01017

Oracle list invalid password ORA-01017

-- 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

9 votes273 views1 answer
Sql server get utc date
SQL
0 vote260 views1 answer
Power bi dax add related shows column but not working
SQL
3 votes276 views2 answers
How to modify rows in SQL Server
SQL
3 votes280 views1 answer
Apex set debug level
SQL
6 votes254 views1 answer
Rank function in oracle with example
SQL
2 votes306 views2 answers
Create temporary table in mysql
SQL
-1 vote296 views1 answer
Get month and year from date in mysql sequelize
SQL
3 votes291 views1 answer
Oracle function return
SQL
0 vote257 views1 answer
Oracle query to see what scema i am working in
SQL
0 vote269 views1 answer
Mysql find db contarint
SQL