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

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Tue, 26 Nov 2002 18:20:11 +0100
Message-ID: <87b7uuof4gm42pti4ufn4o63rv6j23qk2e@4ax.com>

On Tue, 26 Nov 2002 16:45:13 +0100, "Bernd Sonderkoetter" <B.Sonderkoetter_at_smf.de> wrote:

>So I assume that in the described case the Oracle DBMS ignores the select
>rights on C which are *implicitly* granted by a role and only recognizes the
>rights that are *explicitly* granted. If you explicitly grant select rights
>on C for the user, he is able to create the view.

A view is a stored object. Roles are ignored during compilation of any stored procedure/function or package. Roles are ignored because roles are volatile, and the object doesn't need to be recompiled on every execution.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Tue Nov 26 2002 - 11:20:11 CST