Oracle Refresh Group Access

I created refresh group and added materialized views to that group in schema A. I want to refresh from User B. But when I try to view the ALL_REFRESH and ALL_REFRESH_CHILDREN ta开发者_C百科bles in schema B, no data is found. Should some kind of permission be given to user B to see these information ?

Just "grant alter any materialized view to B" and you will be able to see these information and refresh the refresh group.

you can give select privilege to schema B.

or an another option is to grant select on dba views to schema_b_user so that he can view all the MVs in the db

as sys or system user:- grant select_catalog_role to schema_b_user;

and then select on dba_refresh and dba_refresh_children