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 : 27-04-2017

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

  • ora-38610 : FI "string" name prefix is reserved for frequent itemset counting
  • ora-31633 : unable to create master table "string.string"
  • ora-12814 : only one CACHE or NOCACHE clause may be specified
  • ora-14188 : sub-partitioning columns must form a subset of key columns of a UNIQUE index
  • ora-31052 : Cannot delete ACL with other references
  • ora-28606 : block too fragmented to build bitmap index (string,string)
  • ora-01532 : cannot create database; instance being started elsewhere
  • ora-09362 : Windows 3.1 Two-Task driver unable to deallocate context area
  • ora-15062 : ASM disk is globally closed
  • ora-09270 : szalloc: error allocating memory for security
  • ora-30970 : option not supported for XML Index
  • ora-23386 : replication parallel push cannot create slave processes
  • ora-38448 : Indexing predicates with "string" operator is not supported.
  • ora-27211 : Failed to load Media Management Library
  • ora-26065 : check constraint cannot reference column, string, in direct path load
  • ora-01149 : cannot shutdown - file string has online backup set
  • ora-23462 : flavor string in use at site string
  • ora-08231 : smscre: unable to attach to SGA
  • ora-32642 : non-unique cell values from the ORDER BY clause
  • ora-30502 : system triggers cannot have INSERT, UPDATE, or DELETE as triggering events
  • ora-19017 : Attributes can only be simple scalars
  • ora-16515 : no rcv channel
  • ora-13363 : no valid ETYPE in the geometry
  • ora-38778 : Restore point 'string' already exists.
  • ora-09243 : smsget: error attaching to SGA
  • ora-01680 : unable to extend LOB segment by string in tablespace string
  • ora-24317 : define handle used in a different position
  • ora-24502 : codepoint length overflows
  • ora-28048 : database is a member of multiple enterprise domains in OID
  • ora-30199 : reserved for future use
  • 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.