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 : 25-04-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-31414 : error(s) occurred during change table advance
  • ora-19853 : error preparing auxiliary instance string (error string)
  • ora-09881 : sstasfre/sstasdel: shmdt error, unable to detach tas read page
  • ora-21611 : key length [string] is invalid
  • ora-26689 : column datatype mismatch in LCR
  • ora-31197 : Error in processing file string
  • ora-27193 : sbtinfo2 did not return volume label
  • ora-19509 : failed to delete sequential file, handle="string", parms="string"
  • ora-19583 : conversation terminated due to error
  • ora-26029 : index string.string partition string initially in unusable state
  • ora-02772 : Invalid maximum server idle time
  • ora-13628 : Insufficient privileges to access the task belonging to the specified user
  • ora-04017 : invalid value string (length = string) for parameter max_dump_file_size
  • ora-17611 : ksfd: file 'string' cannot be accessed, global open closed
  • ora-38766 : cannot flashback data file string; file resized smaller
  • ora-25532 : MTTR specified is too large: string
  • ora-39769 : finish is not allowed with an incompletely loaded last row
  • ora-02072 : distributed database network protocol mismatch
  • ora-36683 : (XSDPART21) Partition string dimensioned by more than one composite.
  • ora-16583 : bad Data Guard Connection Process DRCX state
  • ora-40108 : input data contains too few distinct target (string) values
  • ora-07221 : slspool: exec error, unable to start spooler program.
  • ora-35180 : (SNSYN103) The format of the OUTFILE command is: OUTFILE [APPEND] {EOF | TRACEFILE | filename [NOCACHE] [NLS_CHARSET name]}
  • ora-32736 : Hang analysis aborted due to wrong message type
  • ora-38738 : Flashback log file is not current copy.
  • ora-33070 : (XSAGDNGL34) In AGGMAP workspace object, all QDRs of dimension workspace object must map to the same dimension position.
  • ora-07478 : scgcmn: cannot get lock status.
  • ora-14259 : table is not partitioned by Hash method
  • ora-27160 : process requested to perform operation
  • ora-14029 : GLOBAL partitioned index must be prefixed
  • 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.