Re: CREATE not just ANY TABLE

Create a procedure in B that creates that table and give execute privilege on that procedure to A.

Martin

Bill Buchan wrote:
>
> 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 Nov 07 2000 - 11:52:39 CST