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 : 21-07-2017
ORA-38467

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

  • ora-32007 : internal
  • ora-28235 : algorithm not available
  • ora-37131 : (XSCCOMP06) Cannot aggregate over COMPRESSED COMPOSITE workspace object using AGGMAP workspace object because the OPERATOR string is not supported for bases of a COMPRESSED COMPOSITE.
  • ora-32304 : materialized views with user-defined types cannot use prebuilt table
  • ora-03218 : invalid option for CREATE/ALTER TABLESPACE
  • ora-18002 : the specified outline does not exist
  • ora-24794 : no active DTP service found
  • ora-12852 : PARALLEL_MIN_SERVERS must be less than PROCESSES, string
  • ora-12419 : null binary label value
  • ora-01023 : Cursor context not found (Invalid cursor number)
  • ora-13351 : two or more rings of a complex polygon overlap
  • ora-07417 : sfareq: One or more database writers not active.
  • ora-22851 : invalid CHUNK LOB storage option value
  • ora-36881 : (XSSRF00) The OLAP DML ROW2CELL function can only be used in a LIMITMAP.
  • ora-29337 : tablespace 'string' has a non-standard block size (string)
  • ora-10269 : Don't do coalesces of free space in SMON
  • ora-16116 : no work available
  • ora-19626 : backup set type is string - can not be processed by this conversation
  • ora-01180 : can not create datafile 1
  • ora-14632 : cannot specify PARALLEL clause when adding a List subpartition
  • ora-12911 : permanent tablespace cannot be temporary tablespace
  • ora-03217 : invalid option for alter of TEMPORARY TABLESPACE
  • ora-31432 : invalid source table
  • ora-38306 : this object is not recoverable standalone
  • ora-04092 : cannot string in a trigger
  • ora-27464 : invalid schedule type string
  • ora-37603 : (XSPGERRTEMPSYSTEM) Ran out of temporary storage while writing to a system temporary analytic workspace. Free some temporary storage immediately. You can do so, for example, by DETACHING an analytic workspace.
  • ora-07286 : sksagdi: cannot obtain device information.
  • ora-16194 : Modifying DB_UNIQUE_NAME requires SID='*' qualifier
  • ora-06703 : TLI Driver: send break message failed
  • 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.