Database Error Messages

ORA-28157

Proxy user 'proxy_user_name' forbidden 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 was forbidden to use a role on behalf of a client through the command ALTER USER client GRANT CONNECT THROUGH proxy WITH ALL ROLES EXCEPT role


Action

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