Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!m7g2000cwm.googlegroups.com!not-for-mail
From: "Martin T." <bilbothebagginsbab5@freenet.de>
Newsgroups: comp.databases.oracle.server
Subject: Re: Generic user in web application and identification in database
Date: 10 Oct 2006 00:46:53 -0700
Organization: http://groups.google.com
Lines: 30
Message-ID: <1160466413.502078.307130@m7g2000cwm.googlegroups.com>
References: <1160133120.156253.32870@i3g2000cwc.googlegroups.com>
NNTP-Posting-Host: 80.120.195.26
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1160466418 19141 127.0.0.1 (10 Oct 2006 07:46:58 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Tue, 10 Oct 2006 07:46:58 +0000 (UTC)
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv:1.8.0.7) Gecko/20060909 Firefox/1.5.0.7,gzip(gfe),gzip(gfe)
X-HTTP-Via: 1.0 GRZ-ISA-KS
Complaints-To: groups-abuse@google.com
Injection-Info: m7g2000cwm.googlegroups.com; posting-host=80.120.195.26;
   posting-account=Doh9dQ0AAAAZpkwYjZionMedl4o1AVmV
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:276892

jatix wrote:
> Hi,
> We have got a web application, using J2EE. For presentation we use jsp,
> but we don't know wich will be the framework (struts, ADF, our own
> framewok, ...).
> Customer has that decission. As server application we work with IAS
> 9.0.4 and as database Oracle 9i.
>
> My question is about users. Customer DBA wants that every user
> application makes his own connection database, i.e. personal database
> users. He talks us, he needs know what user is doing each operation
> (select, update, insert,...) every time.
>
> I want to use an unique connection database (generic user). I want to
> make a connection pool and I'm thinking that the only way is to use a
> generic user, because I have to define the pool in design time (user,
> password, max connections,...)
>
> Customer DBA says that using this method, he always has the same user
> doing operations (generic user) when he sees database tables
>

*scratcheshead* ... :-)

Have you thought about a connection pool per database user? Or will
there only be one session per database user?
Will your web login information be the same as the login info for the
actual database users, or will you have web users with different
information from db users?