Re: Web application passing client info

From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Tue, 5 Jan 2010 08:06:11 -0600
Message-ID: <ad3aa4c91001050606l4020b879n501b5615a776d99f_at_mail.gmail.com>

Sounds like you are looking for sys_context information.

http://www.oracle.com/technology/oramag/code/tips2003/011903.html

On Tue, Jan 5, 2010 at 8:00 AM, Rusnak, Al A CTR (USA) DeCA HQ CI < george.rusnak.ctr_at_deca.mil> wrote:

>
> Good morning,
>
> We run applications that have users logging in from all over the world.
> My question is:
> What code (procedure calls, function calls) do we need to add to our
> applications that will pass the client information (name, etc.) to the
> database when the application makes a connection to the database. All
> connections come in as UPDATE_USER or SELECT_USER and have been granted
> appropriate permissions on the schema owner objects.
>
> We are currently using Oracle 10.2.0.4
>
> Documentation, examples…....
>
> I have not been able to find what I need to pass on . I hope I have
> provided enough information.
>
> Thank you and have a GOOD NEW YEAR !!!
>
> Al Rusnak
> Database Administrator
> Fort Lee, Virginia
> Email: george.rusnak.ctr_at_deca.mil
>
>

-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

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

Received on Tue Jan 05 2010 - 08:06:11 CST