ORA-28156: Proxy user 'string' not authorized to set role 'string' for client 'string'

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

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

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

update : 24-06-2017
ORA-28156

ORA-28156 - Proxy user 'string' not authorized to set role 'string' for client 'string'
ORA-28156 - Proxy user 'string' not authorized to set role 'string' for client 'string'

  • ora-13239 : sdo_dimensionality not specified during n-d R-tree creation
  • ora-31689 : illegal value for base worker id, string
  • ora-39309 : schema sync operation failed
  • ora-03290 : Invalid truncate command - missing CLUSTER or TABLE keyword
  • ora-19695 : fixed table x$krbmsft has not been populated
  • ora-01286 : start interval required
  • ora-33911 : (MAKEDCL29) You cannot define a string in analytic workspace string because it has not been upgraded to version string.
  • ora-09841 : soacon: Name translation failure.
  • ora-02061 : lock table specified list of distributed tables
  • ora-24770 : cannot forget a prepared transaction
  • ora-04060 : insufficient privileges to execute string
  • ora-31668 : Timeout before worker process string finished initialization.
  • ora-37041 : (XSACQUIRE_DEP_TIMEOUT) Composite, concat, dimension map, or internal partition workspace object is locked by another user and the WAIT timed out.
  • ora-13292 : incorrect ARC_TOLERANCE specification
  • ora-04083 : invalid trigger variable 'string'
  • ora-26008 : Invalid syntax or bind variable in SQL string for column string. string
  • ora-00379 : no free buffers available in buffer pool string for block size stringK
  • ora-19813 : cannot have unavailable file string in DB_RECOVERY_FILE_DEST
  • ora-16015 : log string sequence# string not archived, media recovery disabled
  • ora-27140 : attach to post/wait facility failed
  • ora-01254 : cannot end online backup - file string in recovery manager backup
  • ora-36988 : (XSRELGID06) The related dimension of relation workspace object must be of type NUMBER.
  • ora-07845 : sllfcl: LIB$FREE_VM failue
  • ora-22806 : not an object or REF
  • ora-19371 : invalid update option
  • ora-26046 : REF column string expects scoped table name string; user passed in string.
  • ora-36643 : (XSDUNION21) Concat dimension workspace object cannot be changed to NOT UNIQUE because it contains custom member values.
  • ora-25004 : WHEN clause is not allowed in INSTEAD OF triggers
  • ora-12078 : fast refresh of refresh group ID string failed
  • ora-01858 : a non-numeric character was found where a numeric was expected
  • Oracle Database Error Messages



    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.