Can't create view

From: Jan Schaefer <schaefer_at_kksl.uni-leipzig.de>
Date: Mon, 28 May 2001 10:58:23 +0200
Message-ID: <9et3v6$pta$1@news.uni-leipzig.de>

I've created a table and granted SELECT to a user. After this the user was able to create a view basing on my table in his schema.

Then I granted SELECT to a role and granted the role to the user after revoking the direct SELECT grant. Now the user was unable to create the same view on my table. Oracle gives a error message that states: ORA-00942: Table or View does not exist. But the SELECT statement that creates the view still works.

Does anybody know why it's not possible to create the view only with SELECT rights over a role?

Thanks in advance,

Jan Received on Mon May 28 2001 - 03:58:23 CDT