Re: Anything less than CREATE ANY TABLE?

From: Chet Justice <chet.justice_at_pfsf.org>
Date: 19 Apr 2005 13:30:48 -0700
Message-ID: <1113942648.240460.109670@z14g2000cwz.googlegroups.com>

bsand..._at_gmail.com wrote:
> Is there a way to allow a user to be able to create/drop a table in
> another user's schema without having the CREATE ANY TABLE and DROP
ANY
> TABLE privileges? Is there a way to just grant CREATE/DROP within a
> specified schema or schemas?

Frank van Bortel wrote:
>No, and why would you?
>
>Only during the installation of an application you
>would create tables - not on the fly!

I agree with Frank, but if you had to, why not just write a procedure and grant EXECUTE to the user.

CREATE OR REPLACE
PROCEDURE drop_table( p_tablename IN VARCHAR2) IS
BEGIN
EXECUTE IMMEDIATE 'DROP TABLE otheruser.' || p_tablename; END drop_table;

something similar could be written for CREATE TABLE.

chet Received on Tue Apr 19 2005 - 15:30:48 CDT