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: Schema permissions

Re: Schema permissions

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Sat, 17 Jan 2004 12:58:40 +0100
Message-ID: <bp8i00d27a4terbvc8gpspi94dgkjlkouv@4ax.com>


On Sat, 17 Jan 2004 10:58:34 +0100, fehrin_at_t-online.de (Dr. Franz Fehringer) wrote:

>
>Hello,
>
>Is there a possibilty to achieve with grants: User A can create tables in
>schema B but not in schema C?
>
>Greetings
>
>Dr. Franz Fehringer

No, this is not possible
or you must implement something cumbersome as a trigger on the create table command (possible since 8i)

--
Sybrand Bakker, Senior Oracle DBA
Received on Sat Jan 17 2004 - 05:58:40 CST

Original text of this message

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