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
Attachment:
signature.asc
Description: This is a digitally signed message part