/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

2 votes281 views1 answer
Laravel sql String
SQL
0 vote303 views1 answer
Sql quary stuf
SQL
1 vote273 views1 answer
Psql: FATAL: Ident authentication failed for user "postgres"
SQL
0 vote272 views2 answers
How to type a blank discord messgae
SQL
0 vote277 views1 answer
Android sqlite get rows count
SQL
3 votes304 views2 answers
Update part of a string in mysql
SQL
0 vote278 views1 answer
Mysql count grouped rows
SQL
0 vote298 views1 answer
Check user sql password from command line
SQL
10 votes273 views1 answer
Create table oracle
SQL
0 vote292 views1 answer
Create table in dbms cmds
SQL