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 : 29-04-2017
ORA-32836

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

  • ora-25965 : fact table must be included in the from clause
  • ora-19768 : USING clause only valid with ENABLE CHANGE TRACKING
  • ora-25115 : duplicate BLOCK option specification
  • ora-24092 : invalid value string specified
  • ora-16612 : string value too long for attribute "string"
  • ora-26032 : index string.string loading aborted after string keys
  • ora-01175 : data dictionary has more than the string files allowed by the instance
  • ora-31535 : cannot support change source string in this configuration
  • ora-31614 : routine string received this error from string: string
  • ora-26065 : check constraint cannot reference column, string, in direct path load
  • ora-14454 : attempt to reference temporary table in a referential integrity constraint
  • ora-10638 : Index status is invalid
  • ora-30153 : An invalid File Object is passed to the OCIFile function
  • ora-39077 : unable to subscribe agent string to queue "string"
  • ora-12566 : TNS:protocol error
  • ora-29399 : user string does not have privilege to switch to consumer group string
  • ora-27066 : number of buffers in vector I/O exceeds maximum
  • ora-27486 : insufficient privileges
  • ora-29853 : keyword UNIQUE may not be used in creating domain indexes
  • ora-39780 : Direct path context operations are not allowed after the context is aborted or finished
  • ora-38793 : cannot FLASHBACK the database to a future SCN/time
  • ora-39163 : A sample size of string is invalid.
  • ora-14610 : Lob attributes not specified for lob column string for subpartition string
  • ora-01918 : user 'string' does not exist
  • ora-14029 : GLOBAL partitioned index must be prefixed
  • ora-25109 : standby lock name space has illegal character 'string'
  • ora-30018 : Create Rollback Segment failed, USN string is out of range
  • ora-07402 : sprst: cannot restore user signal handler.
  • ora-26064 : Invalid SCN specified - Wrap: string Base: string.
  • ora-30013 : undo tablespace 'string' is currently in use
  • 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.