OracleConnection passing different application name

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm writing a web service that is executing a stored procedure on an Oracle
data server. One of the things that this stored procedure does is to keep
track of 'who' is using it by storing some information from the V$SESSION
view. One of the columns being tracked is the client program name. But, what
I'm getting is the name of the web service, but what I really want is the
name of the program calling the web service.

Part of the framework that we have developped passes the calling program
name, so, I have that. What I don't know is how to pass that program name
instead of the web service program name. Does anyone have any ideas on how
to do this? For instance is there an undocumented keyword/value pair that can
be passed as part of the connection string. Or can I change the program name
attribute of the service?

Thanks
 
The issue is impersonating an application. I do not know how you would
implement this, but that is where I would look for answers, unless you want
to create some mechanism that accepts an application name and circumvents
the native way Oracle works (not advised).

--
Gregory A. Beamer

*************************************************
Think Outside the Box!
*************************************************
 
I know that when I use the Oracle Call Interface (OCI), I have the ability to
supply the program name when making a connection. I was hoping that with the
OracleClient ADO mechanism that I could do the same thing.
 
Hi Jim,

Since it is the web service who is interacting with the Oracle database,
the Oracle database will not see "who" is calling the web service unless
the web service tells it. You can try to add an argument making the web
service identify the client.

Kevin Yu
Microsoft Online Community Support

============================================================================
==========================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
============================================================================
==========================

(This posting is provided "AS IS", with no warranties, and confers no
rights.)
 
Actually, the web service already has the knowledge of who called it (via a
standard framework that we use). I'm wanting to pass that information on to
Oracle.
 
Hi Jim,

If then webservice already knows who is calling it, it can just add a
column in the database and record the caller each time.

Kevin Yu
Microsoft Online Community Support

============================================================================
==========================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
============================================================================
==========================

(This posting is provided "AS IS", with no warranties, and confers no
rights.)
 
Back
Top