Re: Table to get login info??

[Allen Cunningham <allen.cunningham@SONOMA.EDU>]

I don't thing v$session gives much info for 3 tier logins. Everyone appears
to be sysadm.

ac

-----Original Message-----
From: Discussion of SQR, Brio Software's database reporting language
[mailto:SQR-USERS@list.iex.net]On Behalf Of Jennifer Tran
Sent: Thursday, May 30, 2002 2:14 PM
To: SQR-USERS@list.iex.net
Subject: Re: Table to get login info??


You can find that information in V$session...

Allen Cunningham wrote:

> Does anyone know of any Oracle or PeopleSoft tables I can use to get login
> info, e.g., see what oprid is currently logged in, time of login, etc??
> (Using P/S Financials 7.5, Oracle 8i, Tools 7.62, SQR 4.3.4)
>
> Thx,
>
> ac
>
> Allen Cunningham
> Sonoma State University
> Administrative Information Systems
> allen.cunningham@sonoma.edu

--
*********************************
California State University
       -----------
        Jennifer Tran
Email: jtran@bms.calstate.edu
Phone: (562)951-4395

 Making everyday a better day
*********************************