ORA-28181
The proxy user "proxy_user_name" failed to enable one or more of the specified default roles for client user "client_user_name".
- proxy_user_name: The name of the proxy user.
- client_user_name: The name of the client user.
Cause
One or more default roles specified for the client user were not enabled for the proxy user. Only roles directly granted to the client user, not password protected and not a secure application role, can be enabled as a default role.
Action
Review the roles granted to the client user in the DBA_ROLES_PRIVS view. The default role must be directly granted to the client user. Check the DBA_ROLES.AUTHENTICATION_TYPE view for the roles. Only roles with AUTHENTICATION_TYPE=NONE can be default roles. You can do one or more of the following:
- Remove the non-compliant role from the list of default roles.
- Change the AUTHENTICATION_TYPE for the role.
- Enable the role as an application role or password role after login.