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 : 26-09-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-27040 : file create error, unable to create file
  • ora-22608 : cannot add an attribute to the already generated image handle
  • ora-23611 : tablespace "string" has more than one data file
  • ora-02474 : Fixed hash area extents used (string) exceeds maximum allowed (string)
  • ora-30563 : outer join operator (+) not allowed in select-list
  • ora-09884 : Two Task interface: SID doens't match current PU
  • ora-13110 : cannot drop topology with associated topo_geometry tables
  • ora-36952 : (XSFCAST23) You cannot specify a cycle number when querying the string forecasting option.
  • ora-36763 : (XSAGGCNTMOVE01) Aggregation variable workspace object cannot have itself as an AGGCOUNT.
  • ora-13421 : null or invalid cell value
  • ora-14288 : index is not partitioned by Composite Range method
  • ora-13863 : Statistics aggregation for service(module/action) string is not enabled
  • ora-25285 : Invalid value string for array_mode
  • ora-30371 : column cannot define a level in more than one dimension
  • ora-06264 : NETNTT: data protocol error
  • ora-01883 : overlap was disabled during a region transition
  • ora-26705 : cannot downgrade capture process after Streams data dictionary has been upgraded
  • ora-15006 : template "string" does not exist
  • ora-12653 : Authentication control function failed
  • ora-13438 : GeoRaster metadata pyramid type error
  • ora-25012 : PARENT and NEW values cannot be identical
  • ora-31693 : Table data object string failed to load/unload and is being skipped due to error: string
  • ora-29960 : line string, string
  • ora-37069 : You may not execute a parallel OLAP operation against the EXPRESS AW.
  • ora-12221 : TNS:illegal ADDRESS parameters
  • ora-10691 : Set background process core file type (Unix only)
  • ora-22054 : underflow error
  • ora-39004 : invalid state
  • ora-29909 : label for the ancillary operator is not a literal number
  • ora-01792 : maximum number of columns in a table or view is 1000
  • 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.