/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

0 vote162 views1 answer
Oracle date summer time
SQL
0 vote150 views1 answer
How to alter length character varying postgres
SQL
0 vote217 views1 answer
Site:av.ru "files"
SQL
1 vote132 views1 answer
Oracle start job
SQL
1 vote140 views1 answer
Isnull sql server
SQL
0 vote127 views1 answer
First Step in installing SQL workbench
SQL
0 vote140 views1 answer
Oracle current session details
SQL
1 vote155 views1 answer
Mysql show long running queries
SQL
4 votes129 views3 answers
Create database in mySQL
SQL
16 votes159 views5 answers
Select last row in sql
SQL