Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Simple Q re schemas and users

Re: Simple Q re schemas and users

From: Holger Peine <peine_at_iese.fraunhofer.de.omit-this-junk>
Date: Fri, 10 Oct 2003 17:15:29 +0200
Message-ID: <3f86cd4a@news.fhg.de>


Martin Weichert wrote:

> Holger Peine wrote:

>> I have one user MASTER which creates all the tables (thus all tables
>> end up in the MASTER schema), and many other users (some of them
>> created later at run-time) accessing the tables (sometimes via DML
>> statements, sometimes via stored procedures).

>
> Maybe you should consider the following:
> you may have many real-life users accessing the data, but
> do they really have to be separate Oracle users (with own
> database schemas) as well?

Yes, they have to - for security reasons. Each user has different access rights on the data (I use RLS/VPD with security policies based on the current user's identity).

Kind regards,
Holger.

-- 
Dr. Holger Peine
Fraunhofer IESE, Kaiserslautern, Germany
Phone +49-6301-707-134, Fax -209 (shared)
www.iese.fraunhofer.de/Staff/peine -- PGP key on request or via pgp.mit.edu
Received on Fri Oct 10 2003 - 10:15:29 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US