Re: Schema permissions

Giganews Newsgroups
Subject: Re: Schema permissions
Posted by:  Ana C. Dent (anacede…@hotmail.com)
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
There might be a way, but I'm not convinced that it would be worthwhile
implementing.

If in schema B a procedure was created such that it could create new
tables in schema B, then GRANT EXECUTE ON MAKE_TABLE_IN_B TO A;

Replies

None

In response to

Schema permissions posted by fehr…@t-online.de on Sat, 17 Jan 2004