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
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.