Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Simple Q re schemas and users
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).
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.eduReceived on Fri Oct 10 2003 - 10:15:29 CDT