ORA-28108: circular security policies detected

Cause : oPilicsef rot ehs ma eboejtcr fereneece ca htoeh.r

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

rDpot ehp locieis

update : 29-04-2017
ORA-28108

ORA-28108 - circular security policies detected
ORA-28108 - circular security policies detected

  • ora-16702 : generic resource guard warning
  • ora-25952 : join index must only contain inner equi-joins
  • ora-22804 : remote operations not permitted on object tables or user-defined type columns
  • ora-00358 : Too many file members specified, the maximum is string
  • ora-09859 : sfngat: the input file name is not in the autobackup OMF format
  • ora-31000 : Resource 'string' is not an XDB schema document
  • ora-00056 : DDL lock on object 'string.string' is already held in an incompatible mode
  • ora-04081 : trigger 'string' already exists
  • ora-38104 : Columns referenced in the ON Clause cannot be updated: string
  • ora-31659 : status message was invalid type - detaching job
  • ora-01582 : unable to open control file for backup
  • ora-00449 : background process 'string' unexpectedly terminated with error string
  • ora-19104 : invalid XQueryX: missing attribute string
  • ora-26516 : no push transaction acknowledgement
  • ora-31410 : change set string is not an existing change set
  • ora-09809 : Unable to get user's group ID from connection
  • ora-01928 : GRANT option not granted for all privileges
  • ora-38485 : invalid object type for the user-defined function
  • ora-13144 : target table string not found
  • ora-01719 : outer join operator (+) not allowed in operand of OR or IN
  • ora-03262 : the file is non-empty
  • ora-12601 : TNS:information flags check failed
  • ora-26727 : Cannot alter queue_to_queue property of existing propagation.
  • ora-12157 : TNS:internal network communication error
  • ora-01526 : error in opening file 'string'
  • ora-01647 : tablespace 'string' is read only, cannot allocate space in it
  • ora-31693 : Table data object string failed to load/unload and is being skipped due to error: string
  • ora-39301 : schema "string" does not exist or is in use
  • ora-36871 : (XSFTDSC01) Object string cannot be used to define a column in a LIMITMAP.
  • ora-12010 : cannot create materialized view log on table owned by SYS
  • 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.