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

From: Gazza <garywaldrom_at_hotmail.com>
Date: Thu, 11 Nov 1999 16:22:05 -0000
Message-ID: <942337482.24340.0.nnrp-03.c1ed75d0@news.demon.co.uk>

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

--
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
>
>
Received on Thu Nov 11 1999 - 10:22:05 CST