Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Anything less than CREATE ANY TABLE?

Re: Anything less than CREATE ANY TABLE?

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Tue, 19 Apr 2005 22:15:40 +0200
Message-ID: <d43ome$2nh$1@news1.zwoll1.ov.home.nl>


bsandell_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?
>
> Thanks
>

No, and why would you?

Only during the installation of an application you would create tables - not on the fly!

-- 
Regards,
Frank van Bortel
Received on Tue Apr 19 2005 - 15:15:40 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US