Scenario:
User A is missing the grant option for an object owned by user B. User B grants the privilege with grant option to user A.
User A creates a role and adds the privilege to that role, i.e. “GRANT SELECT ON user_b.table_b TO role”;
Grant succeeds, but error ORA-01720 still exists. Logged in an error table.
No idea what the problem could be.