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

Home -> Community -> Usenet -> c.d.o.tools -> Re: How to?: Setup DB schema: How to?

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

From: Rene Nyffenegger <rene.nyffenegger_at_gmx.ch>
Date: 27 Apr 2001 22:31:06 GMT
Message-ID: <Xns90914232ACCBgnuegischgnueg@130.133.1.4>

"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

 
Received on Fri Apr 27 2001 - 17:31:06 CDT

Original text of this message

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