accessing a view from another user

assume:

user a has the table tab_a
user b has select-right on the table tab_a an creates the view view_b

  create view view_b as
  select * from a.tab_a;

this works fine and b can see the content of the table tab_a.

now b grants user c the select-right on his view view_b. but when c tries to look at the view

  select * from b.view_b

he gets an ora-01031: insufficient privileges! why? this even happens with select-rights on the table tab_a from user a! now he could create an own view on the table of user a or look directly on this table, but he still can't open the view of user b!

what must be done that user c can look at the view view_b from user b?

thanx

matthias Received on Wed Sep 15 2004 - 02:39:13 CDT