Re: Schema permissions

Giganews Newsgroups
Subject: Re: Schema permissions
Posted by:  Daniel Morgan (damorg…
Date: Sat, 17 Jan 2004

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:

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
(replace 'x' with a 'u' to reply)



In response to

Schema permissions posted by fehr… on Sat, 17 Jan 2004