Please see response below post: > -----Original Message----- > From: Vijay Kumar [mailto:vijy.gan...@gmail.com] > Sent: Thursday, May 28, 2015 7:22 AM > To: Tomcat Users List > Subject: Re: can we pass OS username while connection Database from > Tomcat > > Hi , > > I am referring User_Id as Linux User_id where we installed Tomcat. > > My Oracle Database don't know about this user_id. > > > Thanks, > Vijay G > Vijay - As another tomcat->oracle integrator, I do have to ask, exactly what is it your client is trying to monitor and what tool is he going to use? But first let's clarify the question: 1) Tomcat is running as the O/S user "apps" and your client wants to see the connections from O/S user apps? And why? This may already be available in the database structures. or 2) Tomcat is connecting to the database using the schema name "apps" and the client want to see these connections? That's already available on the Oracle side. This depends on what tool the client is using. Or 3) the client wants to see the user names of the application users in the monitoring tool? Depending on this answer and the tool used, you are really getting into Oracle programming territory, as there are several ways to do this.
As for answering the straight-forward question, a quick Google search found several replies, all requiring changes to the application code that connects to the database. Actually from what I understand, the Oracle drivers already provide this, at least the latest versions. Jeff > On Thu, May 28, 2015 at 3:20 PM, André Warnier <a...@ice-sa.com> wrote: > > > Vijay Kumar wrote: > > > >> Hi Mark, > >> > >> Please find below my exact requirement. > >> > >> I have Oracle Database where my objects are installed and I have also > a > >> Linux instance where i installed Tomcat. > >> I am currently creating connection to the Oracle database from Tomcat > >> using > >> 'apps' user as this schema is having all permissions. > >> > >> One of my client want to monitor the connections that are created > from my > >> application. For this i want to pass my Linux user information > (userid) > >> while creating the connection from my application or in context.xml > file. > >> > >> Please suggest the approaches? If SPENGO can you redirect me any > doc/post > >> how to achieve this? > >> > >> Vijay, > > you are repeating yourself (and still top-posting), but you are not > > providing the crucial information which would enable someone to really > help > > you. > > For example, what "Linux user information (userid)" are you talking > about ? > > > > Is it the Linux user-id under which Tomcat is running ? > > That would probably be "tomcat", so that is probably not going to help > you > > fulfill your customer's wishes. > > > > Is it the user-id of the /user/ of your Tomcat application ? > > In that case, how does Tomcat know this user-id ? Do the users login > into > > your application ? How ? What is the user authentication mechanism > being > > used, now, at the Tomcat level ? > > > > Does the Oracle database also know this user-id ? How ? > > > > What does "One of my client want to monitor the connections" mean, > exactly > > ? what does the customer want to know, and when ? Is this customer the > only > > user/manager of the Oracle database, or are there multiple > users/managers > > of the Oracle database ? > > > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org > > For additional commands, e-mail: users-h...@tomcat.apache.org > > > > --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
