ORA-28111: insufficient privilege to evaluate policy predicate

Cause : Preidcat ehasa suqbuer ywhihc cotnain sobjcets htat hte onwer fo poilcy ufnctoin deos nto haev prviileeg toa ccess.

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

Gratn aprpopraite rpivielgest o teh poilcy ufnctoin onwer.

update : 30-04-2017

ORA-28111 - insufficient privilege to evaluate policy predicate
ORA-28111 - insufficient privilege to evaluate policy predicate

  • ora-24145 : evaluation context string.string already exists
  • ora-10906 : Unable to extend segment after insert direct load
  • ora-02065 : illegal option for ALTER SYSTEM
  • ora-37130 : (XSCCOMP05) Cannot aggregate over COMPRESSED COMPOSITE workspace object using AGGMAP workspace object because you must specify AGGINDEX OFF when there is a PRECOMPUTE clause on a RELATION over base workspace object.
  • ora-25250 : Cannot specify a remote recipient for the message
  • ora-30436 : unable to open named pipe 'string'
  • ora-16252 : Rebuild operation not permitted
  • ora-25141 : invalid EXTENT MANAGEMENT clause
  • ora-36636 : (XSDUNION04) The unique concat dimension workspace object cannot be changed to NOT UNIQUE, because it is a base of at least one other unique concat dimension.
  • ora-32762 : Turn on Temp LOB Ref Count Tracing
  • ora-36845 : (XSLMGEN15) Owner is greater than 30 bytes
  • ora-07860 : osnsoi: error setting up interrupt handler
  • ora-38709 : Recovery Area is not enabled.
  • ora-22614 : error while construction the collection in the image
  • ora-08434 : raw data has invalid trailing sign
  • ora-02073 : sequence numbers not supported in remote updates
  • ora-00219 : required control file size (string logical blocks) exceeds maximum allowable size (string logical blocks)
  • ora-02061 : lock table specified list of distributed tables
  • ora-09775 : osnmrs: reset protocol error
  • ora-01286 : start interval required
  • ora-07402 : sprst: cannot restore user signal handler.
  • ora-31033 : Requested number of XML children string exceeds maximum string
  • ora-12590 : TNS:no I/O buffer
  • ora-27091 : unable to queue I/O
  • ora-23455 : flavor string contains object "string"
  • ora-01603 : illegal grouping size in clause "string" of string
  • ora-10267 : Inhibit KSEDMP for testing
  • ora-16824 : Fast-Start Failover and other warnings detected for the database
  • ora-24852 : protocol error during statement execution
  • ora-25955 : all tables must be joined in the where clause
  • 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.