Re: Grant table creation

The ANY privileges mean just that. In the case of Create Any Table that means the grantee can create tables belonging to any user.

If you want to create tables under a specific user create a routine under the target schema that uses execute immediate to issue the create table command under the authority of the procedure owner. You could also create the package/procedure under a DBA id and use logic to limit the target schemas to authorized ID's.

HTH -- Mark D Powell -- Received on Thu Apr 28 2005 - 19:11:45 CDT