Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Audit Help

Re: Audit Help

From: Eugene Gardner <Gene_at_VaxMan.prestel.co.uk>
Date: Tue, 05 Jan 1999 19:36:53 GMT
Message-ID: <369242ca.26319620@news.prestel.co.uk>


v$session won't help - it only tells you who is connected right now. No I think you need to look at AUD$ or one of the views based on it. Check out the following script snippit:

select os_username, username,
to_char(timestamp,'dd-Mon-yy hh24:mi:ss') "Logon", to_char(logoff_time,'dd-Mon-yy hh24:mi:ss') "Logoff" from dba_audit_session where timestamp > sysdate - 99 order by 2, to_date (to_char (timestamp,'dd-Mon-yy hh24:mi:ss'),'dd-Mon-yy hh24:mi:ss')

Eugene Gardner (unemployed).



"Jeff Reed" <jgreed_at_edgenet.net> wrote:

> Can someone tell me which table I need to look in to see what users have
> logged on to a database? I do have auditing turned on.
>
> TIA Jeff
>
>
Received on Tue Jan 05 1999 - 13:36:53 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US