Database Error Messages

ORA-28156

Proxy user 'proxy_user_name' not authorized to set role 'role_name' for client 'client_user_name'
  • proxy_user_name: The name of the proxy user.
  • role_name: The name of the role.
  • client_user_name: The name of the client user.

Cause

A proxy user has not been granted the right to use a role on behalf of a client.


Action

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