> From: Regina Harter [mailto:[EMAIL PROTECTED]]
>
>
> Hi
>
> I have a question for any of you involved in Web
> applications. I would
> like to know how many of you go for the single Oracle user
> for everyone
> approach,
Define "everyone". Everyone that navigates onto your website? Gawd no.
> and how many of you create Oracle schemas for each
> user, and if
> you can, what was the major reason for choosing that approach. Any
> opinions you wish to contribute will be helpful.
Here's the thing: I've stopped considering Oracle "users" as analogous to any other kind of "user". They are schema containers; the web app is in charge of managing user access and abstracting the database layer.
Of course, there are exceptions to this guideline. I can't think of any right now, but hey...
