Re: Table to get login info??

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

Tha't the prob I am running into, and most of our campus users are logged-in
3 tier.

ac

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


On Thu, 2002-05-30 at 14:59, 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)

If the people are logged in in 2-tier mode, use v$session, if it is
3-tier, I do not know of a way as these get connected to Oracle via
Tuxedo, so you will see a lot of people connected as the OWNERID of the
database, with your Tuxedo user ID as the OSUSER.

--
...Rob

=====================================================================
Robert Goshko                  Axis Computer Consulting Services, Inc
President                              Sherwood Park, Alberta, Canada
http://www.axis-dev.com/      Supporting the Revolution In Your World
=====================================================================
Registered Linux User #260513

  3:33pm  up  3:12,  2 users,  load average: 0.17, 0.13, 0.10