Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!rip!news.webusenet.com!peer01.cox.net!cox.net!news.maxwell.syr.edu!newsfeed1.swip.net!swipnet!gatekeeper.carmen.se!not-for-mail
From: Martin Weichert <Martin.Weichert@carmensystems.com>
Newsgroups: comp.databases.oracle.misc
Subject: Re: Simple Q re schemas and users
Date: Fri, 10 Oct 2003 16:15:03 +0200
Organization: Carmen Systems AB
Lines: 26
Message-ID: <3F86BEE7.571695C8@carmensystems.com>
References: <3f82bb52@news.fhg.de>
NNTP-Posting-Host: taramajima.carmen.se
Mime-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: webster.carmen.se 1065795304 32352 192.168.100.44 (10 Oct 2003 14:15:04 GMT)
X-Complaints-To: newsmaster@carmen.se
NNTP-Posting-Date: Fri, 10 Oct 2003 14:15:04 +0000 (UTC)
X-Mailer: Mozilla 4.77 [en] (X11; U; SunOS 5.8 sun4u)
X-Accept-Language: eo, sv, de, en
Xref: newssvr20.news.prodigy.com comp.databases.oracle.misc:132189

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? Since they don't have any data
of their own, you probably don't need them. Just create one
separate Oracle user (or maybe a fixed, small number of them
if you need distinct roles with different access rights),
and let different real-life users log on to Oracle as the
same Oracle user. That way you don't have all the hassle with
dynamic creation of Oracle users, synonyms, privileges etc.;
it's enough to do it once in the begining for the fixed number
of Oracle users.

Hope this helps...
  /Martin

-- 
Martin Weichert, Ph.D. - martin.weichert@carmensystems.com
Carmen Systems AB, Odinsgatan 9, S-411 03 Göteborg, Sweden
Phone: +46-(0)31-720 81 98      Fax:   +46-(0)31-720 81 20