RE: To Anyone involved in Web apps

> From: Regina Harter [mailto:rharter_at_emc-inc.com]
>
>
> 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...

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jeremy Pulcifer
  INET: Jeremy.Pulcifer_at_kadiri.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).