"jimmy@age" <jimmyage@noemail.noemail> wrote in message
news:949FA84D-EC4C-4094-AD90-292BC99B82EB@microsoft.com...
> 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
> --
> Jim Noeth

"Cowboy (Gregory A. Beamer)" wrote:

> 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!
> *************************************************
> "jimmy@age" <jimmyage@noemail.noemail> wrote in message
> news:949FA84D-EC4C-4094-AD90-292BC99B82EB@microsoft.com...
> > 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
> > --
> > Jim Noeth
>
>
>

"Kevin Yu [MSFT]" wrote:

> 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.)
>
>