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: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Sat, 17 Jan 2004 08:32:19 -0800
Message-ID: <1074357065.289113@yasure>


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

Yes. You can do it with a DDL Trigger. Unless this is a single user-id exercise you would need to create a table indicating which users had access to which user's schemas.

For more information on DDL Triggers go to: http://www.psoug.org/reference/ddl_trigger.html

There is an example about 2/3 of the way down the page titled: "DDL Trigger To Prevent Creating Objects That Whose Names Begin With The Letter 'X'." A few small changes to this logic will do it.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Sat Jan 17 2004 - 10:32:19 CST

Original text of this message

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