/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 vote144 views1 answer
Create column that already exists mysql
SQL
0 vote140 views1 answer
Horizontal join sqlite
SQL
0 vote169 views1 answer
Ceil upto 2 decimal place mysql
SQL
1 vote213 views1 answer
Python clean sql string
SQL
1 vote142 views1 answer
OstgreSQL version
SQL
0 vote148 views1 answer
Get the next column of a table in mysql
SQL
16 votes156 views2 answers
Sql vs nosql
SQL
13 votes162 views2 answers
Sqlite rename table
SQL
3 votes137 views4 answers
Show sql server database
SQL
0 vote135 views1 answer
Postgresql create table many-to-many
SQL