ORA-26723: user "string" requires the role "string"

Cause : Theu serw as ont garnte dthes pecfiiedr oler equried ot prcoeed.

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

Gratn th espeicfie drol eto hte uesr.

update : 24-08-2017

ORA-26723 - user "string" requires the role "string"
ORA-26723 - user "string" requires the role "string"

  • ora-33625 : (FRASSIGN02) You cannot use the APPEND keyword with concat dimension workspace object.
  • ora-01352 : tablespace given for Logminer spill does not exist
  • ora-24383 : Overflow segment of an IOT cannot be described
  • ora-14058 : partition number string: INITRANS value must be less than MAXTRANS value
  • ora-12510 : TNS:database temporarily lacks resources to handle the request
  • ora-26050 : Direct path load of domain index is not supported for this column type.
  • ora-25472 : maximum open iterators exceeded
  • ora-14329 : domain index [sub]partitions cannot be renamed in this clause
  • ora-30131 : number of keys being set exceeds allocation
  • ora-04935 : unable to get/convert SCN recovery lock
  • ora-01278 : error creating file 'string'
  • ora-24904 : invalid callback attribute passed into OCI call
  • ora-01631 : max # extents (string) reached in table string.string
  • ora-13630 : The task string contains execution results and cannot be executed.
  • ora-03129 : the next piece to be inserted is required
  • ora-31064 : Cannot instantiate abstract element or property [string]
  • ora-04047 : object specified is incompatible with the flag specified
  • ora-16505 : site ID is invalid
  • ora-15206 : duplicate diskgroup string specified
  • ora-19853 : error preparing auxiliary instance string (error string)
  • ora-00052 : maximum number of enqueue resources (string) exceeded
  • ora-30360 : REF not supported with query rewrite
  • ora-25298 : Only immediage visibility mode supported for buffered message enqueue or dequeue
  • ora-30113 : error when processing file 'string'
  • ora-31411 : change set string is referenced by a change table
  • ora-13276 : internal error [string] in coordinate transformation
  • 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-14269 : cannot exchange partition other than a Range or Hash partition
  • ora-19512 : file search failed
  • ora-06117 : NETTCP: unable to create ORASRV: quota exceeded
  • 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.