Re: Priv Required to Create a View

Michael42 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

It is a bad policy to grant CONNECT and RESOURCE.

grant CREATE SESSION, CREATE TABLE, CREATE VIEW, etc. explicitly and only as required.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org