Oracle Error ORA-28156: Proxy user ‘string’ not authorized to set role ‘string’ for client ‘string’

Oracle Error Message

ORA-28156: Proxy user ‘string’ not authorized to set role ‘string’ for client ‘string’

Reason for the Error

A proxy user has not been granted the right to use a role on behalf of a client.

Solution

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