Re: Q: Get OS Userid
From: Fred Schulz <FGSchulz_at_engprn.mobil.com>
Date: Tue, 21 Jun 1994 08:54:43
Message-ID: <FGSchulz.19.0008E9C6_at_engprn.mobil.com>
Date: Tue, 21 Jun 1994 08:54:43
Message-ID: <FGSchulz.19.0008E9C6_at_engprn.mobil.com>
The following query returns both the Oracle and system user id.
SELECT P.USERNAME, S.USERNAME
FROM V$PROCESS P, V$SESSION S
WHERE P.ADDR=S.PADDR AND
S.AUDSID = USERENV('SESSIONID');
When using Windows and SQL*Net TCP/IP, it seems to return OraUser-T, or if the
Can anyone confirm this behavior under Windows?
Thanks,
Fred Schulz
Received on Tue Jun 21 1994 - 08:54:43 CEST