Re: Schema permissions

Giganews Newsgroups
Subject: Re: Schema permissions
Posted by:  Ana C. Dent (anacede…
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

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;



In response to

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