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@xxxxxxxx> 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@xxxxxxxx > > -- Andrew W. Kerber 'If at first you dont succeed, dont take up skydiving.'