Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Schema permissions
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 DBAReceived on Sat Jan 17 2004 - 05:58:40 CST