Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Schema permissions
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