How to fix the Oracle error ORA-28152: proxy user ‘string’ may not specify initial role ‘string’ on behalf of client ‘string’?

In this post, you’ll learn more about the Oracle ErrorORA-28152: proxy user ‘string’ may not specify initial role ‘string’ on behalf of client ‘string’ with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-28152: proxy user ‘string’ may not specify initial role ‘string’ on behalf of client ‘string’

Reason for the Error ORA-28152: proxy user ‘string’ may not specify initial role ‘string’ on behalf of client ‘string’

A proxy user attempted to specify an initial role for a client, but the client does not possess the role.

How to fix the Error ORA-28152: proxy user ‘string’ may not specify initial role ‘string’ on behalf of client ‘string’ ?

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

Change the proxy user so that it does not specify the role or grant the role to the client.