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 : 16-08-2017
ORA-38467

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

  • ora-00206 : error in writing (block string, # blocks string) of control file
  • ora-16134 : invalid MANAGED recovery FINISH option
  • ora-19771 : cannot rename change tracking file while database is open
  • ora-01685 : max # extents (string) reached in index string.string partition string
  • ora-01045 : user string lacks CREATE SESSION privilege; logon denied
  • ora-39766 : invaid stream specified for column array conversion
  • ora-09284 : sllfop: cannot allocate read buffer
  • ora-07241 : slemrd: read error.
  • ora-01299 : dictionary string corresponds to a different database incarnation
  • ora-37080 : Advice requested for hierarchy with too many levels
  • ora-06127 : NETTCP: unable to change username
  • ora-19594 : control file already included as string
  • ora-06721 : TLI Driver: spurious client req
  • ora-13358 : circle type does not contain 3 points
  • ora-00022 : invalid session ID; access denied
  • ora-02302 : invalid or missing type name
  • ora-13431 : GeoRaster metadata rasterType error
  • ora-24127 : TABLESPACE parameter specified with an ACTION other than CREATE_ACTION
  • ora-12467 : minimum label can contain a level only
  • ora-28526 : invalid describe information returned to Heterogeneous Services
  • ora-03132 : two-task default value overflow
  • ora-00163 : internal database name length string is greater than maximum (string)
  • ora-01663 : the contents of tablespace 'string' is constantly changing
  • ora-13498 : %s
  • ora-24850 : failed to startup shared subsystem
  • ora-12950 : SYSTEM tablespace specified as default permanent tablespace
  • ora-08319 : sllfsk: Error reading file
  • ora-12351 : cannot create view using a remote object which has a remote object reference
  • ora-30039 : Cannot drop the undo tablespace
  • ora-29376 : number of consumer groups string in top-plan string exceeds string
  • 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.