From: "Wolf 'n Pinguin" <duif.op.spijkers@wxs.nl>
Newsgroups: comp.databases.oracle.misc,comp.databases.oracle.server
Subject: Schemas and authorizations
Date: 5 May 2001 21:21:21 GMT
Organization: Wolf 'n Pinguin
Lines: 14
Message-ID: <01c0d5a9$61ff8960$2eaa79c3@hester>
NNTP-Posting-Host: ipc379aa2e.dial.wxs.nl
X-Trace: reader01.wxs.nl 989097681 6334057 195.121.170.46 (5 May 2001 21:21:21 GMT)
X-Complaints-To: abuse@wxs.nl
NNTP-Posting-Date: 5 May 2001 21:21:21 GMT
X-Newsreader: Microsoft Internet News 4.70.1155


Hi Everybody,

I have the following problem:

I have a couple of schemas (SCHEMA1, SCHEMA2, SCHEMA3, etc ) each of which
contains  an identical datamodel. The number of schemas can get quite
large.

I wish to create a user, and allow it SELECT privileges on all tables/views
in SCHEMA1 and SCHEMA2, but not on other schemas.

Is there an easy way to accomplish this?

Thanx in advance, Ide