Re: Privileges for registering an XML schema

From: De DBA <dedba_at_tpg.com.au>
Date: Wed, 29 Aug 2012 08:39:36 +1000
Message-ID: <503D48A8.8080809_at_tpg.com.au>

Drop Any? Are you serious? Why would anyone worth his salt grant "DROP ANY DIRECTORY" to non-DBAs? Could do some serious damage..

Tony

On 29/08/12 6:43 AM, Wolfson Larry - lwolfs wrote:
> We just had someone go through this and Think you need all of these
>
> GRANT ALTER SESSION TO&&USER;
> GRANT CREATE SESSION TO&&USER;
> GRANT CREATE SYNONYM TO&&USER;
> GRANT CREATE TABLE TO&&USER;
> GRANT CREATE TYPE TO&&USER;
> GRANT CREATE VIEW TO&&USER;
> GRANT DROP ANY DIRECTORY TO&&USER;
> GRANT RESOURCE TO&&USER;

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Aug 28 2012 - 17:39:36 CDT