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

Hi,

does anybody know why it is not sufficient for creating a view to have granted select rights by a ROLE on a table which is used in the view? This is under
the assumption that the table belongs to another user and the view is to be
created in your own schema.

Example:

CREATE VIEW TEST ( A ) AS SELECT B FROM C WHERE... results in the error ORA-00942: table or view does not exist if the select right on C is granted by a role and C belongs to another user.

Is this a bug or a feature?

Thanks,
Bernd Received on Tue Nov 26 2002 - 04:47:18 CST