Oracle Error ORA-28157: Proxy user ‘string’ forbidden to set role ‘string’ for client ‘string’

Oracle Error Message

ORA-28157: Proxy user ‘string’ forbidden to set role ‘string’ for client ‘string’

Reason for the Error

A proxy user was forbidden to use a role on behalf of a client through the command ALTER USER GRANT CONNECT THROUGH WITH ALL ROLES EXCEPT

Solution

Execute the command ALTER USER GRANT CONNECT THROUGH PROXY to grant the needed role.