Re: V6 Grant to view

In article <1995Jan3.212647.8477_at_emma.ruc.dk>, mettej_at_emma.ruc.dk (Mette Jespersen) writes:
|>Granting to views on tables owned by system and others
|>
|>I've got problems - when I'm granting to a view, based on tables owned by
|>system and another user.
|>
|>I've made a view based on 2 tables owned by system and 2 tables owned by
|>another user. I've granted select to public on all tables, and granted ALL to public
|>on the view. BUT I'ts only users which have been granted DBA, who can acces the
|>view??? Other users can create a copy of the view, and acces it without
|>problems.
|>
|>Is there a special restriction on system-owned tables, that I'm not aware
|>of?
|>
|>Thanks for your help
|>- Mette
|>

What version of the RDBMS are you running?

In version 7.0.16.6.0 (and maybe others) there is a bug that we have come across also.

Reference Oracle bug numbers 170985 & 215242

Regards,
Chas. Dye Received on Wed Jan 04 1995 - 17:28:26 CET