How to fix the Oracle error ORA-28181: proxy ‘string’ failed to enable one or more of the specified initial roles for client ‘string’?

In this post, you’ll learn more about the Oracle ErrorORA-28181: proxy ‘string’ failed to enable one or more of the specified initial roles for client ‘string’ with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-28181: proxy ‘string’ failed to enable one or more of the specified initial roles for client ‘string’

Reason for the Error ORA-28181: proxy ‘string’ failed to enable one or more of the specified initial roles for client ‘string’

Attempt to enable specified initial roles after logon resulted in failure.

How to fix the Error ORA-28181: proxy ‘string’ failed to enable one or more of the specified initial roles for client ‘string’ ?

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

Check that the initial roles are valid, granted to client, and not password protected.