RE: Need OS User from Web Service call

From: TJ Kiernan <tkiernan_at_pti-nps.com>
Date: Fri, 11 Jan 2013 12:23:34 -0600
Message-ID: <3DC440E2338A24439D527C2E64E1ECBCA852CD_at_deeds.pti-nps.com>

Change the default

SQLNET.AUTHENTICATION_SERVICES= (NTS) to

SQLNET.AUTHENTICATION_SERVICES= (NONE) in the client's sqlnet.ora. Worked for us (there may be some odp.net parameters I'm also unaware of, so sorry if this is an incomplete answer).

Thanks,
T. J.
�

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jeff Chirco Sent: Friday, January 11, 2013 10:27 AM
To: oracle-l_at_freelists.org
Subject: Need OS User from Web Service call

Currently for our .Net applications call a web service that runs in IIS which then access the Oracle database. When I query v$session the OS User listed as making the call shows as "SYSTEM". Does anybody know if it is possible to have the actual OS User that made the originating call? I am not sure if this is possible because the call is going through a middle tier. Thanks.

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Fri Jan 11 2013 - 19:23:34 CET

This message: [ Message body ]
Next message: Job Miller: "Re: Need OS User from Web Service call"
Previous message: Kevin Closson: "Re: Hyperthreading - Oracle license"
In reply to: Jeff Chirco: "Need OS User from Web Service call"
Next in thread: Job Miller: "Re: Need OS User from Web Service call"
Reply: Job Miller: "Re: Need OS User from Web Service call"
Reply: mohammed bhatti: "Re: Need OS User from Web Service call"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message