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

To be clear:

User creating the view has select rights on C ( and granted by C's owner AFTER synonym[ public or private?] was created)? Is that the case?

"Bernd Sonderkoetter" <B.Sonderkoetter_at_smf.de> wrote:

>No, this is not the problem because a synonym on table c does exist!
>
>"Guido Konsolke" <Guido.Konsolke_at_Triaton.com> schrieb im Newsbeitrag
>news:1038308790.752445_at_news.thyssen.com...
>> Bernd wrote ...
>> >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
>>
>> Hi Bernd,
>> maybe my (only *this*) thought is totally wrong, couldn't verify it.
>> If you're lucky you only have to add the schema name to the
>> table C. This will read "Select B from schema.C Where...".
>> If that really is your prob, you can also solve it by creating
>> a synonym for table C.
>>
>> Sorry if my suggestions are obvious silly...
>> Guido
>>
>>
>
Received on Tue Nov 26 2002 - 09:04:49 CST