ORA-28155: user 'string' specified as a proxy is actually a role

Cause : A user specified in an AUDIT BY ON BEHALF OF is actually a role.

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

Execute the statement again with a valid proxy user.

update : 23-04-2017
ORA-28155

ORA-28155 - user 'string' specified as a proxy is actually a role
ORA-28155 - user 'string' specified as a proxy is actually a role

  • ora-06713 : TLI Driver: error on connect
  • ora-26672 : timeout occurred while stopping STREAMS process string
  • ora-29929 : missing SCAN Keyword
  • ora-09350 : Windows 32-bit Two-Task driver unable to allocate context area
  • ora-27047 : unable to read the header block of file
  • ora-19564 : error occurred writing string bytes at block number string
  • ora-07262 : sptpa: sptpa called with invalid process id.
  • ora-10919 : Default temporary tablespace group must have at least one tablespace
  • ora-19239 : XP0019 - step expression must return sequence of nodes
  • ora-33332 : (DSSEXIST01) Use the AW command to establish a current analytic workspace. Then start your current activity again.
  • ora-21602 : operation does not support the specified typecode
  • ora-39104 : cannot call this function from a SQL parallel query slave process
  • ora-13446 : GeoRaster metadata TRS error
  • ora-12636 : Packet send failed
  • ora-32037 : unsupported use of LEVEL in membership condition
  • ora-38790 : BEFORE must be specified with RESETLOGS
  • ora-06575 : Package or function string is in an invalid state
  • ora-28336 : cannot encrypt SYS owned objects
  • ora-24341 : bad mode specified
  • ora-37010 : (XSACQUIRE_DIFFAW) When using the CONSISTENT WITH clause, all objects must come from the same analytic workspace.
  • ora-30744 : "string" is not an object table
  • ora-14076 : submitted alter index partition/subpartition operation is not valid for local partitioned index
  • ora-24190 : length of payload exceeds string
  • ora-32620 : illegal subquery within MODEL rules
  • ora-13527 : invalid baseline name
  • ora-09320 : szrfc: unable to obtain the list of valid OS roles
  • ora-01670 : new datafile string needed for standby database recovery
  • ora-26736 : Data Pump error
  • ora-29888 : cannot create domain index on a table with row movement enabled
  • ora-27145 : insufficient resources for requested number of processes
  • 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.