Re: CREATE not just ANY TABLE

From: <jdarrah_co_at_my-deja.com>
Date: Wed, 25 Oct 2000 15:51:41 GMT
Message-ID: <8t6vib$fmk$1@nnrp1.deja.com>

You could create a package owned by B that accepts a string (the create table statement) and uses dynamic sql to execute it. Then grant execute on the package to A. Not a great solution.

In article <39f5c2d2.32480721_at_nntp.edi.noha-systems.com>, wbuchan_at_uk.noha-systems.com (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.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Oct 25 2000 - 10:51:41 CDT