Roles in oracle

I created a view in schema A using snapshots in schema B. I was trying to assign roles to the view. But it doesnt allow me to. It says there is some error related to access开发者_开发技巧 to the tables from the snapshots.

Any ideas?

Schema B needs to grant schema A select on the snapshots "WITH GRANT OPTION" ("WITH ADMIN OPTION" is only for system privileges, not object privileges):

grant select on TABLE_NAME to A with grant option;

Schema B needs to grant schema A select on the snapshots "with grant option" for schema A to be able to pass on the grants to other schemas/roles.

GRANT SELECT ON my_table TO a WITH GRANT OPTION;