grant on view

We have a user SI2 who has about 300 user tables. we have created a view in this account which does a join between a user table and all_tab_columns.

create view v_test as
select a.table_name,a.column_name,b.id
from all_tab_columns a

     my_table b
where b.table_name=a.table_name

We have granted select rights on this view to a role ROLE_SI2, and this role is granted to user SI2USR.

If we select from the view in account SI2 we see the info but if we select in SI2USR we see nothing.

Now when i read an oracle textbook, it says that for views when you grant select , you have also to give grant on the underling base table.
I can do this for my_table,
but all_tab_columns is a synonym
and am i suppose to give grants to all 300 tables in account SI2.

Please mail solution to gino.blyau_at_dg19.cec.be thank you.

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet