ORA-28023: must revoke grants of this role to other user(s) first

Cause : Teh orl eatleerdt oI DNETFIIDE LGOABLYL awsg rnatde ot noeo rm oer tohre suesr nado/rr oels .Golbla orlse acnontb eg rnatde ot nayu sre ro orl.e

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

Ues ERVKOEt or eovk eteh orl eformo tehru sreso rr oelsf isrt.

update : 29-04-2017

ORA-28023 - must revoke grants of this role to other user(s) first
ORA-28023 - must revoke grants of this role to other user(s) first

  • ora-00126 : connection refused; invalid duplicity
  • ora-10631 : SHRINK clause should not be specified for this object
  • ora-08191 : Flashback Table operation is not supported on remote tables
  • ora-26673 : duplicate column name string
  • ora-23533 : object "string"."string" can not be cached
  • ora-01680 : unable to extend LOB segment by string in tablespace string
  • ora-00723 : Initialization parameter COMPATIBLE must be explicitly set
  • ora-28300 : No permission to read user entry in LDAP directory service.
  • ora-25505 : the system is not in quiesced state
  • ora-38757 : Database must be mounted and not open to FLASHBACK.
  • ora-23366 : integer value string is less than 1
  • ora-14639 : SUBPARTITIONS clause can be specfied only for Hash, Composite Range Hash table/partition
  • ora-06608 : LU6.2 Driver: Reset occurred in receive state
  • ora-24038 : RETRY_DELAY and MAX_RETRIES cannot be used for a 8.0 compatible multiple consumer queue
  • ora-13121 : layer type type mismatch with topo_geometry layer type
  • ora-37071 : You may not execute a parallel OLAP operation against updated but uncommitted AW string.
  • ora-19732 : incorrect number of datafiles for tablespace string
  • ora-01698 : a clone database may only have SYSTEM rollback segment online
  • ora-23397 : global name "string" does not match database link name "string"
  • ora-30025 : DROP segment 'string' (in undo tablespace) not allowed
  • ora-01603 : illegal grouping size in clause "string" of string
  • ora-29509 : incorrectly formed Java binary class definition
  • ora-16091 : dependent archive log destination already archived
  • ora-25289 : Buffer Already Exists
  • ora-13352 : the coordinates do not describe a circle
  • ora-00059 : maximum number of DB_FILES exceeded
  • ora-07207 : sigpidu: process ID string overflows internal buffer.
  • ora-12541 : TNS:no listener
  • ora-16765 : Redo Apply is unexpectedly online
  • ora-08263 : ora_addr: cannot free listener address
  • 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.