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

Home -> Community -> Usenet -> c.d.o.server -> Re: Priv Required to Create a View

Re: Priv Required to Create a View

From: <nospamdrew_at_gmail.com>
Date: 10 Apr 2007 15:51:42 -0700
Message-ID: <1176245502.033051.88550@l77g2000hsb.googlegroups.com>


On Apr 10, 3:29 pm, "Michael42" <melliot..._at_yahoo.com> wrote:
> Hello,
>
> In an Oracle 10g R2 database I created a user with CONNECT and
> RESOURCE roles. They can create their own tables in their schema but
> not views. What priviledge is required for a user to be able to
> create a view?
>
> Thanks,
>
> Michael

Hey Michael-

You'll have to connect to the instance as a DBA and issue a command like this:
grant create view to <user>
/

replace <user> with the user you granted CONNECT and RESOURCE to. Received on Tue Apr 10 2007 - 17:51:42 CDT

Original text of this message

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