Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Audit Help
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).
> 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