I don't know where you are looking, but what about the fields
OSUSER
PROCESS
MACHINE
TERMINAL
in the v$session-view - wouldn't the help?
--
Regards
Kurt Laugesen
KurtL_at_corebit.dk
+45 40 90 49 30
DianeB <diane_at_adventservices.freeserve.co.uk> wrote in message
news:7s40ac$rtm$1_at_news7.svr.pol.co.uk...
> We are running Oracle Fiancials with the client software running on NT 4.0
> (actually its Windows Terminal Server)
> I want to be able to identify the users which are attached to the
database.
> All Fiancials users come in as "APPS" database user.
> and the TERMINAL field is always set to "Windows PC". How can I establish
> who is connected to the database in terms of either their NT login name or
> their Client PC.
>
> Many thanks in advance
>
> DB
>
>
Received on Mon Sep 20 1999 - 07:14:18 CDT
