ORA-28150: proxy not authorized to connect as client

Cause : A proxy user attempted to connect as a client, but the proxy was not authorized to act on behalf of the client.

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

Grant the proxy user permission to perform actions on behalf of the client by using the ALTER USER ... GRANT CONNECT command.

update : 25-04-2017

ORA-28150 - proxy not authorized to connect as client
ORA-28150 - proxy not authorized to connect as client

  • ora-02471 : SYSDATE, UID, USER, ROWNUM, or LEVEL incorrectly used in hash expression.
  • ora-08106 : cannot create journal table string.string
  • ora-38605 : FI not enough memory(stringK) for candidate generation(stringK)
  • ora-29859 : error occurred in the execution of ODCIINDEXTRUNCATE routine
  • ora-16575 : request terminated at broker discretion
  • ora-30727 : duplicate referential constraint for a REF column
  • ora-16637 : an instance failed to access the Data Guard broker configuration
  • ora-27091 : unable to queue I/O
  • ora-00342 : archived log does not have expected resetlogs SCN string
  • ora-00237 : snapshot operation disallowed: control file newly created
  • ora-04002 : INCREMENT must be a non-zero integer
  • ora-31528 : could not find change set string for CDC subscription string
  • ora-08181 : specified number is not a valid system change number
  • ora-01166 : file number string is larger than string (string)
  • ora-25153 : Temporary Tablespace is Empty
  • ora-36181 : A VARIABLE cannot have both the $AGGREGATE_FROM and $AGGREGATE_FROMVAR properties applied to it.
  • ora-26673 : duplicate column name string
  • ora-29505 : AS keyword is invalid in CREATE JAVA CLASS or RESOURCE
  • ora-38755 : Flashback is already turned on for this tablespace.
  • ora-14405 : partitioned index contains partitions in a different tablespace
  • ora-01203 : wrong incarnation of this file - wrong creation SCN
  • ora-23358 : invalid remote user
  • ora-07608 : szprv: $GETUAI failure
  • ora-13387 : sdo_batch_size for array inserts should be in the range [number,number]
  • ora-25452 : duplicate attribute value for variable: string, attribute: string
  • ora-25280 : complete sender information not provided to non-repudiate sender
  • ora-12625 : TNS:missing argument
  • ora-02439 : Unique index on a deferrable constraint is not allowed
  • ora-30735 : cannot create multiple subtables of the same type under a supertable
  • ora-32009 : cannot reset the memory value for instance string from instance 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.