Re: HELP Design question --- Where should I create Application accounts

From: Rick Wessman <rwessman_at_us.oracle.com>
Date: 12 Nov 1999 09:27:41 -0800
Message-ID: <sochfirboxe.fsf@rwessman-sun.us.oracle.com>

"Gazza" <garywaldrom_at_hotmail.com> writes:

> I would create the tables under an application owner account and then
> generate public synonyms on all objects with each individual user having an
> oracle account. This allows for better auditing facilities and access
> control using roles and object privileges etc.
>
> Slightly more admin but for 10 users...! Shouldn't be a problem
I definitely agree. It also would reduce the amount of redundancy. Oracle already provides user authentication (through a variety of means) and authorization. Re-inventing the wheel would just mean that you would have to resolve issues that Oracle has already resolved.

                                              Rick

>
>
> --
> Gazza
>
> Seigmund Akinwande Johnson <asjohns_at_midway.uchicago.edu> wrote in message
> news:3OjW3.92$j4.2318_at_uchinews...
> > I am developing an application, that requires 10 users, should I create
> one
> > oracle user account for the
> > application itself or 10 separate oracle accounts.
> >
> > Creating one application account, would require me to create a user table
> > and the application itself uses
> > only one account to login, once logged in I can validate users on my own
> > user table
> >
> > Otherwise I simply create the accounts in Oracle, and leave authentication
> > to oracle database
> >
> > --
> > Developer
> > BSDIS
> > 773-834-2652
> >
> >
>
>

--

                                Thanks,
                                Rick
                                Rick Wessman
                                Server Security Group
                                Oracle Corporation
                                rwessman_at_us.oracle.com

     The opinions expressed above are mine and do not necessarily reflect
                         those of Oracle Corporation.

Received on Fri Nov 12 1999 - 11:27:41 CST