/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 vote314 views1 answer
Join creating duplicate columns sqllite
SQL
0 vote312 views1 answer
Where date in datetime mysql
SQL
0 vote303 views1 answer
Python mysql query to dataframe
SQL
0 vote296 views1 answer
Composit key in sql
SQL
0 vote322 views1 answer
Create_engine sqlalchemy with parsed url sql server
SQL
-1 vote324 views1 answer
SQL SERVER microsoft How to Add Column at Specific Location in Table
SQL
1 vote306 views1 answer
Oracle sql create view
SQL
1 vote311 views1 answer
Md5 encryption for existing records
SQL
1 vote305 views1 answer
ELECT list is not in GROUP BY clause and contains nonaggregated column 'schogdsw_db.SE.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
0 vote307 views1 answer
Sql server size of every table in a db
SQL