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 : 24-06-2017
ORA-38467

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

  • ora-01256 : error in locking database file string
  • ora-01901 : ROLLBACK keyword expected
  • ora-25963 : join index must be created on tables
  • ora-21707 : pin duration is longer than allocation duration
  • ora-02778 : Name given for the log directory is invalid
  • ora-13402 : the rasterType is null or not supported
  • ora-09779 : snyGetPort: failure to allocate a port.
  • ora-00308 : cannot open archived log 'string'
  • ora-02283 : cannot alter starting sequence number
  • ora-23431 : wrong state: string
  • ora-01310 : requested return type not supported by the lcr_mine function
  • ora-01943 : IDENTIFIED BY already specified
  • ora-33278 : (DBERR09) Analytic workspace string cannot be attached in RW or EXCLUSIVE mode until the changes made and updated in MULTI mode are committed or rolled back.
  • ora-30081 : invalid data type for datetime/interval arithmetic
  • ora-28163 : GRANT already specified
  • ora-27062 : could not find pending async I/Os
  • ora-09764 : osnmop: access error on oracle executable
  • ora-02836 : Unable to create temporary key file
  • ora-23456 : flavor string does not contain "string"
  • ora-13609 : The specified task string must be executing to be cancelled or interrupted.
  • ora-02250 : missing or invalid constraint name
  • ora-17626 : ksfdcre: string file exists
  • ora-24085 : operation failed, queue string is invalid
  • ora-09889 : osnTXtt: access error on oracle executable
  • ora-29385 : cannot create plan directive from string to string
  • ora-12827 : insufficient parallel query slaves available
  • ora-06766 : TLI Driver: close failed during release
  • ora-01569 : data file too small for system dictionary tables
  • ora-30737 : cannot create subtable of a type which is not a subtype of the type of the supertable
  • ora-16643 : unable to determine location of broker configuration files
  • 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.