ORA-28024: must revoke grants of external roles to this role/user

Cause : The uesr or orle aletred t oIDENTFIIED GOLBALLYh as exetrnal orles driectlyg rante d- thees mustb e revkoed, snice exetrnal orles cnanot b egrantde to golbal uesrs orr oles.

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

Use RVEOKE t orevok ethe etxernalr oles rfom th euser ro rolet o be LATERed.

update : 25-06-2017

ORA-28024 - must revoke grants of external roles to this role/user
ORA-28024 - must revoke grants of external roles to this role/user

  • ora-25178 : duplicate PCTTHRESHOLD storage option specification
  • ora-15032 : not all alterations performed
  • ora-22911 : duplicate storage specification for the nested table item
  • ora-30933 : Element 'string' may not appear at this point within parent 'string'
  • ora-01921 : role name 'string' conflicts with another user or role name
  • ora-29821 : specified primary operator does not exist
  • ora-22995 : TABLESPACE DEFAULT option is invalid in this context
  • ora-29973 : Unsupported query or operation during change notification registration
  • ora-01525 : error in renaming data files
  • ora-14325 : only LOCAL indexes may be specified in this clause
  • ora-24347 : Warning of a NULL column in an aggregate function
  • ora-01220 : file based sort illegal before database is open
  • ora-25303 : Buffered operation allowed only on the owner instance
  • ora-00487 : CTWR process terminated with error
  • ora-30024 : Invalid specification for CREATE UNDO TABLESPACE
  • ora-04061 : existing state of string has been invalidated
  • ora-02365 : error seeking in file: string
  • ora-31413 : change set string is currently being advanced
  • ora-01776 : cannot modify more than one base table through a join view
  • ora-38744 : file string is not the same file seen at start of flashback
  • ora-07405 : sptrap: cannot setup alternate signal stack.
  • ora-27024 : skgfqsbi: sbtinit2 returned error
  • ora-13607 : The specified task or object string already exists
  • ora-23304 : malformed deferred rpc at arg string of string in call string, in tid string
  • ora-06767 : TLI Driver: alloc failed during release
  • ora-25264 : cant get signature for this queue
  • ora-28656 : incomplete attribute specification
  • ora-16245 : paging in transaction string, string, string
  • ora-15050 : disk "string" contains string error(s)
  • ora-04013 : number to CACHE must be less than one cycle
  • 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.