ORA-28157: Proxy user 'string' forbidden to set role
'string' for client 'string'



ORA-28157: Proxy user 'string' forbidden to set role 'string' for client '..

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-26576: cannot acquire SR enqueue

1 Answers  


TNS-00502: Invalid argument

1 Answers  


ORA-31158: schema "string" currently being referenced

1 Answers  


PCB-00553: FOR clause not allowed on this statement

1 Answers  


ORA-16231: DDL barrier

1 Answers  






ORA-24344: success with compilation error

1 Answers  


ORA-38408: The ADT "string" does not exist in the current schema.

1 Answers  


RMAN-06571: datafile number does not have recoverable copy

1 Answers  


ORA-32316: REFRESH FAST of "string"."string" unsupported after mixed DML

1 Answers  


ORA-19552: device type string is invalid

1 Answers  


RMAN-08051: cataloged archive log

1 Answers  


ORA-00341: log string of thread string, wrong log # string in header

1 Answers  


Categories