Re: Grant table creation

Joan wrote:

> I want to allow user A to create tables, but just on schemas B and C.
> I am not sure if privilege CREATE ANY TABLE can be granted for a specific schema.
> If not, any ideas ?
>
> Thanks.

Not possible as you have stated it and not a good practice in the way I think you intend it.

Why don't you state the business case rather than your proposed solution.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)