ORA-23406: insufficient privileges on user "string"

Cause : Th ecalleri s ont hte wone roft hem atreiailze dviwe adn deos ont ahveA LTRE AYN MTAERAILIEZD IVEWp riivleegs.

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

Pefror mth eopreatoin sa teh onwero f hte amteiralziedv ie wora s ausre wtih LATE RAN YMAETRILAIZDE VEIW rpivliegse.

update : 27-06-2017
ORA-23406

ORA-23406 - insufficient privileges on user "string"
ORA-23406 - insufficient privileges on user "string"

  • ora-31069 : Cannot apply typed changes to non-schema-based XMLType nodes
  • ora-34656 : (MXSQL24) Additional WHERE clause conditions with CURRENT OF syntax
  • ora-23532 : tables with different synchronization mechanisms are in the same group
  • ora-02719 : osnfop: fork failed
  • ora-22813 : operand value exceeds system limits
  • ora-23468 : missing string string
  • ora-28100 : policy function schema string is invalid
  • ora-13262 : geometry column string does not exist in table string
  • ora-32142 : maximum number of iterations exceeded
  • ora-30079 : cannot alter database timezone when database has TIMESTAMP WITH LOCAL TIME ZONE columns
  • ora-16209 : Logical standby dictionary build failed to complete.
  • ora-24306 : bad buffer for piece
  • ora-30438 : unable to access named pipe 'string'
  • ora-38421 : attribute string already exists
  • ora-27166 : tried to join current thread
  • ora-19015 : Invalid XML tag identifier (string)
  • ora-32001 : write to SPFILE requested but no SPFILE specified at startup
  • ora-10261 : Limit the size of the PGA heap
  • ora-23354 : deferred RPC execution disabled for "string" with "string"
  • ora-06732 : TLI Driver: cannot alloc t_discon
  • ora-37005 : (AWLISTALL03) number readers
  • ora-22975 : cannot create a PRIMARY KEY-based REF to this object view
  • ora-30159 : OCIFileOpen: Cannot create the file or cannot open in the requested mode
  • ora-12660 : Encryption or crypto-checksumming parameters incompatible
  • ora-32125 : Attribute type is not appropriate
  • ora-25505 : the system is not in quiesced state
  • ora-15038 : disk 'string' size mismatch with diskgroup [string] [string] [string]
  • ora-06431 : ssaio: Invalid Block number
  • ora-08340 : This command not allowed on nCUBE, only one thread is ever used.
  • ora-31411 : change set string is referenced by a change table
  • 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.