CREATE not just ANY TABLE

Hi,

If I have 3 users A, B and C is there any way to allow A to create tables in B's schema but _not_ C's.

ie. CREATE TABLE is too restrictive as then A can only create tables in A, but CREATE ANY TABLE is too unrestrictive as A can create tables anywhere.

Is there is a middle ground?

Thanks
- Bill. Received on Tue Oct 24 2000 - 12:14:30 CDT