ORA-32836: database user string must be granted role string

Cause : The specified database user does not have a required role.

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

Grant the user the indicated role.

update : 30-05-2017
ORA-32836

ORA-32836 - database user string must be granted role string
ORA-32836 - database user string must be granted role string

  • ora-31605 : the following was returned from string in routine string: LPX-number: string
  • ora-30081 : invalid data type for datetime/interval arithmetic
  • ora-08231 : smscre: unable to attach to SGA
  • ora-06504 : PL/SQL: Return types of Result Set variables or query do not match
  • ora-01651 : unable to extend save undo segment by string for tablespace string
  • ora-08468 : mask option string is not supported
  • ora-02431 : cannot disable constraint (string) - no such constraint
  • ora-01085 : preceding errors in deferred rpc to "string.string.string"
  • ora-36637 : (XSDUNION05) The concat dimension cannot be defined as UNIQUE because it has a non-unique concat base dimension workspace object.
  • ora-16171 : RECOVER...FINISH not allowed due to gap for thr string, seq string-string
  • ora-02217 : duplicate storage option specification
  • ora-14108 : illegal partition-extended table name syntax
  • ora-39304 : conflicting changes to object "string" : string
  • ora-02476 : can not create index due to parallel direct load on table
  • ora-06730 : TLI Driver: unable to open clone device
  • ora-00214 : control file 'string' version string inconsistent with file 'string' version string
  • ora-36765 : (XSAGGCNTMOVE03) A string aggregation variable cannot have a string AGGCOUNT.
  • ora-01314 : Name of the column to be mined should be a string literal
  • ora-03204 : the segment type specification should indicate partitioning
  • ora-01646 : tablespace 'string' is not read only - cannot make read write
  • ora-31621 : error creating master process
  • ora-31482 : invalid option for non-distributed Hotlog change source
  • ora-12675 : External user name not available yet
  • ora-12630 : Native service operation not supported
  • ora-32510 : cannot create watchpoint on unreadable memory
  • ora-28171 : unsupported Kerberos version
  • ora-00290 : operating system archival error occurred. See error below
  • ora-28100 : policy function schema string is invalid
  • ora-37133 : (XSCCOMP08) You cannot write into an aggregated VARIABLE dimensioned by a COMPRESSED COMPOSITE. Use the CLEAR AGGREGATES command to reenable write access.
  • ora-07496 : sppst: lm_post 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.