ORA-27486: insufficient privileges

Cause : nAa ttmetpw sam da eotp reofmra s hcdelureo eparitnow tiohtut ehr qeiuer drpviligese.

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

sA k ausffcieitnylp iriveleg dsuret oepfrro mht eeruqseet dporetaoi,no rrgna tht eeruqridep iriveleg sott ehp orep rsures(.)

update : 24-08-2017

ORA-27486 - insufficient privileges
ORA-27486 - insufficient privileges

  • ora-36269 : (XSCGMDLAGG10) 'workspace object' does not exist or is not a dimension.
  • ora-36612 : (XSLMS01) invalid OLAP message number: value
  • ora-04060 : insufficient privileges to execute string
  • ora-13850 : Tracing for client identifier string is not enabled
  • ora-37601 : (XSPGERRTEMP) Ran out of temporary storage while writing to analytic workspace with ID=number. Free some temporary storage immediately. You can do so, for example, by DETACHING an analytic workspace.
  • ora-16744 : the DG_CONFIG list of LOG_ARCHIVE_CONFIG parameter is full
  • ora-12819 : missing options in PARALLEL clause
  • ora-12434 : invalid audit type: string
  • ora-16717 : clearing parameter LOG_ARCHIVE_DUPLEX_DEST failed
  • ora-12200 : TNS:could not allocate memory
  • ora-30156 : Out of disk space
  • ora-36883 : (XSSRF02) The first parameter of an AW single row function cannot be NULL.
  • ora-23301 : mixed use of deferred rpc destination modes
  • ora-02805 : Unable to set handler for SIGTPA
  • ora-14136 : ALTER TABLE EXCHANGE restricted by fine-grained security
  • ora-29311 : export dump file was not generated by this database, string does not match
  • ora-12016 : materialized view does not include all primary key columns
  • ora-27457 : argument string of job "string.string" has no value
  • ora-25151 : Rollback Segment cannot be created in this tablespace
  • ora-30576 : ConText Option dictionary loading error
  • ora-28155 : user 'string' specified as a proxy is actually a role
  • ora-02830 : Segment could not be split - no free segments available
  • ora-12716 : Cannot ALTER DATABASE CHARACTER SET when CLOB data exists
  • ora-14137 : Table in partially dropped state, submit DROP TABLE PURGE
  • ora-02144 : no option specified for ALTER CLUSTER
  • ora-24131 : table string has incorrect columns
  • ora-09967 : unable to create or open lock file
  • ora-22875 : cannot drop primary key of an object table whose object identifier is primary key based
  • ora-29811 : missing STATISTICS keyword
  • ora-01304 : subordinate process error. Check alert and trace logs
  • 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.