Tuesday, August 18, 2020

FAILED LOGIN ATTEMPTS ORACLE

 

! HPRD:atlas.ecp.priv:/dbapps/oracle> sqlplus / as sysdba


SQL*Plus: Release 11.2.0.4.0 Production on Tue Aug 18 02:40:33 2020


Copyright (c) 1982, 2013, Oracle.  All rights reserved.



Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options


SQL> audit create session whenever not successful;



select os_username,  username, userhost,  to_char(timestamp,'mm/dd/yyyy hh24:mi:ss') 

logon_time,  action_name, returncode from dba_audit_session order by 4 desc;

No comments:

Post a Comment