|Subject:||Re: Schema permissions|
|Posted by:||Daniel Morgan (damorg…@x.washington.edu)|
|Date:||Sat, 17 Jan 2004|
Dr. Franz Fehringer wrote:
> Is there a possibilty to achieve with grants: User A can create tables in
> schema B but not in schema C?
> 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:
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.
(replace 'x' with a 'u' to reply)
Schema permissions posted by fehr…@t-online.de on Sat, 17 Jan 2004