ORA-28022: cannot grant external roles to global user or role

Cause : Ar oel rgatne dwsa DIETNIIFE DETXENRALLY .Etxenra lrloe scnanto eb rgatne dt ogolbla suesr ro lgoablr oels.

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

Ues LATRE ORL Et ocahneg htet yep fo hter oel ebign rgatne d(rfo mIEDNITFEIDE XETRANLYL ot tohre,s uhc sa DIETNIIFE DB Ypsasowr)d,o ru s eATLE RRLOEo rA LETRU SRE ot hcagnet h etpyeo ft h euesro rr oel hta ti steh rgatne.e

update : 23-06-2017
ORA-28022

ORA-28022 - cannot grant external roles to global user or role
ORA-28022 - cannot grant external roles to global user or role

  • ora-22053 : overflow error
  • ora-01647 : tablespace 'string' is read only, cannot allocate space in it
  • ora-00385 : cannot enable Very Large Memory with new buffer cache parameters
  • ora-12626 : TNS:bad event type
  • ora-08437 : invalid picture type in picture mask
  • ora-36401 : (XSSPROPOTYPE) Property string may only be applied to objects of type string.
  • ora-13011 : value is out of range
  • ora-30566 : Index maintainence clause not allowed for this command
  • ora-04060 : insufficient privileges to execute string
  • ora-28029 : could not authorize remote server for user string
  • ora-00053 : maximum number of enqueues exceeded
  • ora-24028 : cannot create a reciever non-repudiable single consumer queue
  • ora-03297 : file contains used data beyond requested RESIZE value
  • ora-13128 : current tiling level exceeds user specified tiling level
  • ora-06037 : NETDNT: connect failed, node unreachable
  • ora-30751 : cannot disable column string from storing objects of type string.string
  • ora-25406 : could not generate a connect address
  • ora-15058 : disk 'string' belongs to an incompatible diskgroup
  • ora-09705 : spcre: cannot initialize latch semaphore
  • ora-02035 : illegal bundled operation combination
  • ora-33280 : (DBERR10) Analytic workspace string cannot be attached in MULTI mode until the changes made and updated in RW or EXCLUSIVE mode are committed or rolled back.
  • ora-12492 : DBLOW cannot be changed
  • ora-14306 : List value 'string' specified twice in partitions 'string', 'string'
  • ora-24366 : migratable user handle is set in service handle
  • ora-16045 : circular archive log destination dependency chain
  • ora-29543 : Java command string not yet implemented
  • ora-23385 : replication parallel push string argument not valid
  • ora-31656 : cannot use TABLESPACE_EXPR filter with transportable mode
  • ora-32116 : Buffer size is less than amount specified
  • ora-02882 : sou2o: Could not register SGA for protection
  • 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.