Re: How to find OS username for a session??
From: Robert C. Nix <nix_at_gate.net>
Date: 1995/12/12
Message-ID: <30CE46A6.561B_at_gate.net>#1/1
where audsid = userenv('sessionid');
--
return tuser;
--
end;
Date: 1995/12/12
Message-ID: <30CE46A6.561B_at_gate.net>#1/1
create or replace function osuser return varchar2 is
--
tuser varchar2(200);
--
begin
--
select osuser
into tuser from v$session
where audsid = userenv('sessionid');
--
return tuser;
--
end;
Run this as sys, grant execute to public and create apublic synonym and it becomes as good as USER.
-- ______________________ Robert C. nix_at_gate.netReceived on Tue Dec 12 1995 - 00:00:00 CET