Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Cannot compile some views...

Re: Cannot compile some views...

From: <sybrandb_at_hccnet.nl>
Date: Sat, 02 Jun 2007 17:28:01 +0200
Message-ID: <vt2363p0ns9d1n00s5517hgc02v8qc716h@4ax.com>


On Sat, 2 Jun 2007 17:22:33 +0200, "astalavista" <nobody_at_nowhere.com> wrote:

>Hi,
>
>I have some views in a schema which I can't compile from user system
>these views have select ... from select ...
>but I can compile from the owner.

So why don't you compile them from the owner?
>
>So these views are not automatically compiled when used.
Nonsense. Views are only recompiled when invalidated. They are invalidated when you change anything on which the view is depending.

>For others views I can compile from system.
>
>Any clues ?
>
>is it a bug or a feature ?
>Oracle 8.1.7.0
>

Likely neither of those, but just not reading the manual: views are *stored objects*. Stored objects disregard privileges provided by roles.
This has been posted here at least a ZILLION times, and even you could have read that.

-- 

Sybrand Bakker
Senior Oracle DBA
Received on Sat Jun 02 2007 - 10:28:01 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US