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