/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 vote326 views1 answer
Npm ERR! code ELIFECYCLE npm ERR! errno 1 npm ERR! [email protected] install: `node-pre-gyp install --fallback-to-build` npm ERR! Exit status 1 npm ERR! npm ERR! Failed at the [email protected] install script.
SQL
2 votes354 views1 answer
Power query concatenate
SQL
-1 vote344 views1 answer
How to create foreign key in sql server management studio
SQL
1 vote329 views2 answers
Sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) unable to open database file
SQL
0 vote361 views1 answer
Get create sql of hibernqte entity
SQL
0 vote354 views1 answer
Sql create text column limited values
SQL
6 votes331 views1 answer
Rank function in oracle with example
SQL
4 votes349 views1 answer
Mysql not equal
SQL
0 vote359 views1 answer
Sql include rows with 0 values
SQL
14 votes368 views2 answers
Install mysqldump
SQL