Re: Cannot compile some views...

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