Solved

oracle security

Posted on 2015-02-09
4
108 Views
Last Modified: 2015-03-05
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
0
Comment
Question by:Sarma Vadlamani
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 74

Expert Comment

by:sdstuber
ID: 40598444
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
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 40598451
>>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:
http://docs.oracle.com/cd/E11882_01/server.112/e10575/tdpsg_auditing.htm#TDPSG50000
0
 
LVL 74

Accepted Solution

by:
sdstuber earned 500 total points
ID: 40598482
sys.aud$ is the underlying table of   dba_audit_trail

it's recommended to use the views rather than the underlying tables
0
 
LVL 74

Expert Comment

by:sdstuber
ID: 40647792
why the penalty grade?
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.

729 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question