Re: multiple database users

[prev] [thread] [next] [Date index for 2005/06/03]

From: William Ross
Subject: Re: multiple database users
Date: 08:42 on 03 Jun 2005

On 2 Jun 2005, at 18:43, Hartmaier Alexander wrote:

> Hi list!
>
> I just found out that one of my scripts is using the wrong db user =20
> to access my database.
>
> I created different users with different access rights in oracle I =20
> used before CDBI.
>
> The connection info is stored in the base class so a different user =20=

> means a different db connection regardless which parameter is =20
> different.
>
> This topic was already on the list but for different databases but =20
> I think it=92s the same problem
It is the same problem. If you want cdbi to use a different database =20
handle under different circumstances, you need a sub db_Main() in =20
your base class (or wherever) that selects the handle according to =20
your criteria. That sub needs to return an appropriate =20
DBIx::ContextualFetch object, btw, and should be as quick as possible =20=

as it's called very frequently.


will=

multiple database users
Hartmaier Alexander 17:43 on 02 Jun 2005

Re: multiple database users
Andreas Fromm 07:13 on 03 Jun 2005

Re: multiple database users
William Ross 08:42 on 03 Jun 2005

Re: multiple database users
Hartmaier Alexander 10:29 on 06 Jun 2005

Re: multiple database users
Mark Addison 11:20 on 06 Jun 2005

Re: multiple database users
William Ross 11:39 on 06 Jun 2005

Re: multiple database users
Tony Bowden 13:09 on 06 Jun 2005

Re: multiple database users
Mark Addison 13:34 on 06 Jun 2005

Re: multiple database users
Perrin Harkins 14:30 on 06 Jun 2005

Re: multiple database users
Hartmaier Alexander 11:31 on 06 Jun 2005

Re: multiple database users
Hartmaier Alexander 11:51 on 06 Jun 2005

Re: multiple database users
William Ross 13:46 on 06 Jun 2005

Re: multiple database users
Hartmaier Alexander 14:03 on 06 Jun 2005

Re: multiple database users
William Ross 15:30 on 06 Jun 2005

Re: multiple database users
Hartmaier Alexander 16:44 on 06 Jun 2005

Re: multiple database users
William Ross 18:26 on 06 Jun 2005

Re: multiple database users
Jay Strauss 02:53 on 07 Jun 2005

Re: multiple database users
Perrin Harkins 03:58 on 07 Jun 2005

Re: multiple database users
William Ross 10:23 on 07 Jun 2005

Re: multiple database users
Hartmaier Alexander 09:28 on 07 Jun 2005

Re: multiple database users
Perrin Harkins 12:49 on 07 Jun 2005

Re: multiple database users
Hartmaier Alexander 12:49 on 07 Jun 2005

Re: multiple database users
Perrin Harkins 12:54 on 07 Jun 2005

Re: multiple database users
Hartmaier Alexander 13:02 on 07 Jun 2005

Re: multiple database users
Mark Addison 13:47 on 07 Jun 2005