Re: Priv Required to Create a View

From: Mladen Gogala <mgogala.SPAM_ME.NOT_at_verizon.net>
Date: Wed, 11 Apr 2007 13:30:21 GMT
Message-ID: <pan.2007.04.11.13.30.22@verizon.net>

On Tue, 10 Apr 2007 15:29:33 -0700, Michael42 wrote:

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

It's so called RTFM privilege:
http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14220/ toc.htm

-- 
http://www.mladen-gogala.com

Received on Wed Apr 11 2007 - 08:30:21 CDT