How to fix the Oracle error ORA-28157: Proxy user ‘string’ forbidden to set role ‘string’ for client ‘string’?

In this post, you’ll learn more about the Oracle ErrorORA-28157: Proxy user ‘string’ forbidden to set role ‘string’ for client ‘string’ with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

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

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

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

How to fix the Error ORA-28157: Proxy user ‘string’ forbidden to set role ‘string’ for client ‘string’ ?

You can fix this error in Oracle by following the below steps

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