?
Solved

oracle security

Posted on 2015-02-09
4
Medium Priority
?
109 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 1500 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

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

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

Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Suggested Courses

777 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