Re: Generic user in web application and identification in database

On Oct 6, 1:12 pm, "jatix" <jat..._at_gmail.com> 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
>
> May I give to DBA information about which user application is doing
> operations though I use a generic user database ?
>
> EXAMPLE
>
> NOW
>
> Application connectDatabase Database audit tables
>
> a_user_1 --> user_www select, insert,... --> (user: user_www)
> a_user_2 --> user_www select, insert,... --> (user: user_www)
> ...
> a_user_n --> user_www select, insert,... --> (user: user_www)
>
> WHISHED
>
> Application connect Database Database audit tables
>
> a_user_1 --> user_www select, insert, ... --> (user: a_user_1)
> a_user_2 --> user_www select, insert, ... --> (user: a_user_2)
> ...
> a_user_n --> user_www select, insert, ... --> (user: a_user_3)
>
> Regards.

If you use Oracle Single SignOn and Oracle Internet Directory (can come with IAS depending on version) you can set up externally authenticated users, who are linked to one database account. They will be treated as different users though.
If you don't use that mechanism, Oracle doesn't have any facilities, and it is entirely up to you.

-- 
Sybrand Bakker
Senior Oracle DBA