Unanswered: Access to the objects, granted by role, within trigger
Please help me to solve such a problem!
I grant access on the objects X,Y within scheme A to role R.
Then user A grants role R to user B.
Now user B can access X and Y from PL\SQL.
But when he tries to access this objects from trigger, he receives the error "object (table or package) does not exists".
If A grants access directly to user B and doesn't use role, all works well (trigger compiles).
Can i anyway walk around this restriction and use role?