Solved

oracle security

Posted on 2015-02-09
4
107 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

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
error in my cursor 5 60
oracle forms question 22 61
error doing substr 3 51
SQL Syntax Question 9 56
How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
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 how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

734 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