Windows user login?? 3

[BG12424]

Is there a way to get the Windows user login from a stored procedure in oracle? Thanks


regards,
Brian

http://www.gainesconsulting.com

 

[dbtoo2001]

select sys_context('USERENV','SESSION_USER') from dual;

 

[Turkbear]

Hi,
Does not work for me..

Connected to:
Oracle8i Enterprise Edition Release 8.1.5.1.0 - Production
With the Partitioning and Java options
PL/SQL Release 8.1.5.1.0 - Production

SQL> select sys_context('USERENV','SESSION_USER') from dual;

SYS_CONTEXT('USERENV','SESSION_USER')
--------------------------------------------------------------------------------
WAREHOUSE

SQL>

It knows my Oracle login but not my UserName in Windows or the Network

 

[BG12424]

That gets the oracle login. I'm looking for the WinNT login through windows authentication mode. Thanks


regards,
Brian

http://www.gainesconsulting.com

 

[dbtoo2001]

If you have DBA role:
SELECT
s.username ora_uid,
s.osuser usr,
s.machine machine,
s.program apps
FROM v$sess_io io,
v$process p,
v$session s
WHERE s.paddr = p.addr
AND s.sid = io.sid
AND s.TYPE = 'USER';

 

[sem]

Try this:

select osuser from v$session where audsid=sys_context('USERENV','SESSIONID')

This should return OS login name for current user. You may modify where clause to get information about others. Of course, it works only for client/server.

Regards, Dima

 

[BG12424]

Thank you for all the replies. I got it to work.


regards,
Brian

http://www.gainesconsulting.com