Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Priv Required to Create a View
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