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 -> Re: How to?: Setup DB schema: How to?

Re: How to?: Setup DB schema: How to?

From: Anurag Sharma <asharma2_at_osf1.gmu.edu>
Date: 28 Apr 2001 01:37:24 GMT
Message-ID: <9cd6sk$h8r@portal.gmu.edu>

In comp.databases.oracle.misc Rene Nyffenegger <rene.nyffenegger_at_gmx.ch> wrote: : "andrew_webby at hotmail" <spam_at_no.thanks.com> wrote in : <988368197.14521.0.nnrp-07.c30bdde2_at_news.demon.co.uk>:  

:>Anurag, it is worth creating the objects etc under a different (ie.
:>typically 'not an application user' if you know what I mean) schema, and
:>then, as Daniel says, actually granting user1, user2 etc access to it
:>from there.
 

: However, I suppose, what Anurag wanted, was that when user1 creates an 
: object, user2 sees it. So, it would probably be better to stick with mutual 
: grants.
 

: Rene

: -- 
: Rene Nyffenegger
: rene dot nyffenegger at adp-gmbh dot ch
 

:

Many thanks for the information,
Anurag Received on Fri Apr 27 2001 - 20:37:24 CDT

Original text of this message

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