Re: Generic user in web application and identification in database

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? Received on Tue Oct 10 2006 - 02:46:53 CDT