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-06-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-16100 : not a valid Logical Standby database
  • ora-24337 : statement handle not prepared
  • ora-13339 : LRS polygon clipping across multiple rings
  • ora-29335 : tablespace 'string' is not read only
  • ora-29537 : class or resource cannot be created or dropped directly
  • ora-01715 : UNIQUE may not be used with a cluster index
  • ora-15151 : missing or invalid version number for rolling upgrade or downgrade
  • ora-37027 : (XSMLTRESYNC02) Object workspace object cannot be resynced without modified object workspace object because they share a modified composite dimension.
  • ora-24091 : Destination queue string is the same as the source queue
  • ora-01351 : tablespace given for Logminer dictionary does not exist
  • ora-22926 : specified trim length is greater than current LOB value's length
  • ora-30021 : Operation not allowed on undo tablespace
  • ora-19374 : invalid staging table
  • ora-08208 : ora_addr: cannot read from address file
  • ora-09960 : Unable to establish signal handler for termination signal
  • ora-35756 : (VCTODT02) 'number' is not a valid date because number is out of range for a year.
  • ora-01882 : timezone region string not found
  • ora-02275 : such a referential constraint already exists in the table
  • ora-23430 : argument "string" cannot be NULL or empty string
  • ora-30368 : ATTRIBUTE cannot determine column in a different relation
  • ora-35024 : (QFCHECK04) The analytic workspace and EIF file definitions of workspace object have mismatched time dimension attributes.
  • ora-13283 : failure to get new geometry object for conversion in place
  • ora-24168 : rule string.string cannot have default evaluation context
  • ora-24021 : queue table definition not imported for string.string
  • ora-39037 : Object type path not supported for string metadata filter.
  • ora-32403 : cannot use new values from mv log on "string"."string"
  • ora-02757 : osnfop: fork_and_bind failed
  • ora-12150 : TNS:unable to send data
  • ora-04063 : %s has errors
  • ora-14130 : UNIQUE constraints mismatch in ALTER TABLE EXCHANGE PARTITION
  • 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.