Cause: A proxy user was forbidden to use a role on behalf of a client through the command ALTER USER <client> GRANT CONNECT THROUGH <proxy> WITH ALL ROLES EXCEPT <role> See the solution below.
Error solution: Execute the command ALTER USER <client> GRANT CONNECT THROUGH PROXY <proxy> to grant the needed role.
Database version: Oracle 11g Release 2 (11.2)