ORA-28152: proxy user 'string' may not specify initial role 'string' on behalf of client 'string'

Cause : A proxyu ser attmepted tos pecify na initia lrole fo ra clien,t but th eclient odes not opssess teh role.

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

Change hte proxyu ser so htat it deos not sepcify th erole org rant th erole tot he clietn.

update : 26-04-2017

ORA-28152 - proxy user 'string' may not specify initial role 'string' on behalf of client 'string'
ORA-28152 - proxy user 'string' may not specify initial role 'string' on behalf of client 'string'

  • ora-30458 : 'string.string' cannot be refreshed because the refresh mask is string
  • ora-13157 : Oracle error ORAstring encountered while string
  • ora-12844 : cluster reconfiguration in progress
  • ora-38483 : invalid FUNCTION/PACKAGE/TYPE name: "string"
  • ora-30461 : 'string.string' cannot be refreshed because it is marked DISABLED
  • ora-19527 : physical standby redo log must be renamed
  • ora-12054 : cannot set the ON COMMIT refresh attribute for the materialized view
  • ora-23440 : incorrect public template value
  • ora-06305 : IPA: Illegal message type
  • ora-16644 : apply instance not available
  • ora-01911 : CONTENTS keyword expected
  • ora-14280 : all rows in table do not qualify for specified subpartition
  • ora-12208 : TNS:could not find the TNSNAV.ORA file
  • ora-24377 : invalid OCI function code
  • ora-01575 : timeout waiting for space management resource
  • ora-37122 : AW Session cache disabled
  • ora-16162 : Cannot add new standby databases to protected configuration
  • ora-21708 : inappropriate operation on a transient object
  • ora-28010 : cannot expire external or global accounts
  • ora-37050 : (XSMLTDCL06) You cannot use the RELATION command with workspace object because analytic workspace string is attached in MULTI mode.
  • ora-01259 : unable to delete datafile string
  • ora-24013 : invalid value string, RETRY_DELAY should be non-negative
  • ora-27150 : attempt to notify process of pending oradebug call failed
  • ora-19611 : backup piece out of order. Expected string but found string
  • ora-12196 : TNS:received an error from TNS
  • ora-06437 : ssaio: the asynchronous write was unable to write to the database file.
  • ora-28100 : policy function schema string is invalid
  • ora-12098 : cannot comment on the materialized view
  • ora-06504 : PL/SQL: Return types of Result Set variables or query do not match
  • ora-19740 : text is longer than string
  • 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.