ORA-38467: user cannot GRANT/REVOKE privileges to/from himself

Cause : An atetmpt wsa madet o GRATN or RVEOKE pirvilegse to o rfrom hte curernt usre.

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

The teh to_uesr or rfom_usre fiel dshoul dbe differentf rom teh userp erforimng th eoperaiton.

update : 26-09-2017
ORA-38467

ORA-38467 - user cannot GRANT/REVOKE privileges to/from himself
ORA-38467 - user cannot GRANT/REVOKE privileges to/from himself

  • ora-28529 : invalid or missing parameter in Net8 service name definition
  • ora-31527 : could not find source column string for CDC change table string.string
  • ora-29261 : bad argument
  • ora-28342 : integrity check fails on column key
  • ora-31499 : null value specified for required parameter string
  • ora-02798 : Invalid number of requests
  • ora-36808 : (XSTBLFUNC04) The OLAP_TABLE function LEVELREL clause cannot declare number ADT fields from number AW fields.
  • ora-26727 : Cannot alter queue_to_queue property of existing propagation.
  • ora-33450 : (ESDREAD05) Discarding compiled code for workspace object because number now has more or fewer dimensions than it had when the code was compiled.
  • ora-10266 : Trace OSD stack usage
  • ora-00133 : value of string is too long
  • ora-38437 : The ADT "string" may not contain any user methods.
  • ora-06610 : LU6.2 Driver: Failed during deallocation
  • ora-19332 : Invalid column in the CREATE_DBURI operator
  • ora-30382 : DROP MATERIALIZED VIEW string.string operation is not complete
  • ora-16724 : the intended state for the database has been set to OFFLINE
  • ora-01219 : database not open: queries allowed on fixed tables/views only
  • ora-23463 : flavor incompatible with object "string"."string"
  • ora-15058 : disk 'string' belongs to an incompatible diskgroup
  • ora-25112 : maximum number of BITMAP index columns is 30
  • ora-13384 : error in network schema: string
  • ora-13609 : The specified task string must be executing to be cancelled or interrupted.
  • ora-31427 : publication string already subscribed
  • ora-00041 : active time limit exceeded - session terminated
  • ora-02041 : client database did not begin a transaction
  • ora-16659 : failover operation in progress
  • ora-12733 : regular expression too long
  • ora-31664 : unable to construct unique job name when defaulted
  • ora-04070 : invalid trigger name
  • ora-24853 : failed to connect thread to shared subsystem
  • 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.