RE: Why does this "create view" statement fail?

  • From: Paul Baumgartel <treegarden@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Tue, 27 Apr 2004 08:29:31 -0700 (PDT)

It's not just PL/SQL, it's any stored object (such as a view), that
requires privileges to have been granted directly.

--- "Daiminger, Helmut" <HELMUT.DAIMINGER@xxxxxx> wrote:
> Hi Peter,
> 
> I thought that direct grants (i.e. not through roles) would only be
> necessary with PL/SQL blocks...



        
                
__________________________________
Do you Yahoo!?
Win a $20,000 Career Makeover at Yahoo! HotJobs  
http://hotjobs.sweepstakes.yahoo.com/careermakeover 
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: