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

From: Paul Baumgartel <treegarden_at_yahoo.com>
Date: Tue, 27 Apr 2004 08:29:31 -0700 (PDT)
Message-ID: <20040427152931.18966.qmail@web13426.mail.yahoo.com>

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_at_WWK.DE> 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_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Tue Apr 27 2004 - 10:57:15 CDT