oracle security

As part of the Security clean up i  need a report listing users with accounts that have not been accessed in 90 days or greater.  with the below fields.

can you please tell me which oracle table keeps this audit information.thanks.
1.  User Name
2.  Last signed on date
3.  Last signed on time
Sarma VadlamaniprogrammeranalystAsked:
Who is Participating?
sdstuberConnect With a Mentor Commented:
sys.aud$ is the underlying table of   dba_audit_trail

it's recommended to use the views rather than the underlying tables
if you don't have auditing turned on to collect logons then there is no "last signed on" information  in 11gR2 and lower

if you do have auditing on for logon then look in dba_audit_trail

if you have 12c then  dba_users has a last_login column
slightwv (䄆 Netminder) Commented:
>>oracle table keeps this audit information.thanks

If you have auditing turned on and set to DB then it is SYS.AUD$.  There are other locations for the audit records.

I would start in the online docs:
why the penalty grade?
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.