Re: CREATE VIEW: Table or view does not exist (ORA-00942)

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Thu, 28 Nov 2002 20:01:54 -0000
Message-ID: <3de7ba3c$1_2@mk-nntp-1.news.uk.worldonline.com>

"Paul Brewer" <paul_at_paul.brewers.org.uk> wrote in message news:3de54228_2_at_mk-nntp-1.news.uk.worldonline.com...

> You cannot create a stored object using privileges from a role
>
> Just to clarify:
> YOU CANNOT CREATE A STORED OBJECT USING PRIVILEGES FROM A ROLE
> (sorry for shouting).
>
> Regards,
> Paul
>
> P.S. Try 'set role none;' then do the select, then create the view.
>
>
>

Sorry; yesterday was a bad day.
Didn't mean to sound so ill-tempered.

Regards,
Paul Received on Thu Nov 28 2002 - 14:01:54 CST