How to fix the Oracle error ORA-28165: proxy ‘string’ may not specify password-protected role ‘string’ for client ‘string’?

In this post, you’ll learn more about the Oracle ErrorORA-28165: proxy ‘string’ may not specify password-protected 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-28165: proxy ‘string’ may not specify password-protected role ‘string’ for client ‘string’

Reason for the Error ORA-28165: proxy ‘string’ may not specify password-protected role ‘string’ for client ‘string’

A proxy user attempted to activate a role on behalf of a client which has a password associated with it. Since the proxy does not have a password, this activation cannot be allowed.

How to fix the Error ORA-28165: proxy ‘string’ may not specify password-protected role ‘string’ for client ‘string’ ?

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

Attempt to activate a different role or change the role administratively so that there is no password.