Home » RDBMS Server » Security » Who locked oracle user (oracle 12c Windows 2012)
Who locked oracle user [message #673085] Mon, 05 November 2018 06:47 Go to previous message
muthukrish104
Messages: 71
Registered: November 2017
Member
Hi Everyone,

I want to know who locked the account.

Our parameter setup is:-

audit_file_dest                      string                           C:\ORACLE\ORA12C\HOME\DBS\ADMIN\ADUMP
audit_sys_operations                 boolean                          TRUE
audit_trail                          string                           DB


And I am using the below query:-

select
    os_username,
   username,
   userhost,terminal client,
   action_name,
   returncode,timestamp
from
      dba_audit_session
      where
      returncode='1017'
      and
      username=='<username>'
      order by timestamp desc

But it is not showing the latest details of the account lock. Am I missing anything.?

Also, what is the difference of using the below query:-

select terminal,userhost,spare1,ntimestamp# from aud$
where
returncode='1017'
and
userid='<username>'
order by ntimestamp# desc


Regards
M.Krish
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: DBA_USER privilege
Next Topic: standby database error ORA-28374
Goto Forum:
  


Current Time: Mon Jan 20 18:18:36 CST 2020