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: Create object in other schemas?

Re: Create object in other schemas?

From: sybrandb <sybrandb_at_gmail.com>
Date: 30 Nov 2006 14:32:22 -0800
Message-ID: <1164925942.460675.98760@80g2000cwy.googlegroups.com>

wagen123_at_yahoo.com wrote:
> Oracle10g 10.2.0.1
>
>
> I have the following request:
>
> User1 should be able to create/drop objects in schemas A, B and C ONLY.
> There are other schemas in the database such as D,E,F + the system
> accounts where user1 is not permitted to create/drop objects.
>
> Any idea of how this can be accomplished without writing procedures,
> etc.
>
> Thanks

not

-- 
Sybrand Bakker
Senior Oracle DBA
Received on Thu Nov 30 2006 - 16:32:22 CST

Original text of this message

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