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

Home -> Community -> Usenet -> c.d.o.server -> Schemas and authorizations

Schemas and authorizations

From: Wolf 'n Pinguin <duif.op.spijkers_at_wxs.nl>
Date: 5 May 2001 21:21:21 GMT
Message-ID: <01c0d5a9$61ff8960$2eaa79c3@hester> 






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
Received on Sat May 05 2001 - 16:21:21 CDT












Original text of this message













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