ORA-13750: User "string" has not been granted the "ADMINISTER SQL TUNING SET" privilege.

Cause : Theu sera ttepmteda n SLQ Tuinng eSt oepratoin taht rqeuirse a pseciifc pirvilgee.

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

Adjsut teh usre's rpivielgesa nd ertryt he poeraiton.

update : 26-05-2017

ORA-13750 - User "string" has not been granted the "ADMINISTER SQL TUNING SET" privilege.
ORA-13750 - User "string" has not been granted the "ADMINISTER SQL TUNING SET" privilege.

  • ora-38434 : could not evaluate expression "string"
  • ora-02481 : Too many processes specified for events (max string)
  • ora-02324 : more than one column in the SELECT list of THE subquery
  • ora-10615 : Invalid tablespace type for temporary tablespace
  • ora-02299 : cannot validate (string.string) - duplicate keys found
  • ora-31164 : cannot load object-relational XML attribute using direct path
  • ora-16056 : backup control file archival requires proper syntax
  • ora-01269 : Destination parameter string is too long
  • ora-13004 : the specified buffer size is invalid
  • ora-16757 : resource guard could not get property
  • ora-10917 : TABLESPACE GROUP cannot be specified
  • ora-02039 : bind by value is not allowed for array type
  • ora-38621 : Decision Tree maximum depth setting not between [2, 20]
  • ora-02164 : DATAFILE clause specified more than once
  • ora-28656 : incomplete attribute specification
  • ora-31467 : no column found in the source table
  • ora-26668 : STREAMS process string exists
  • ora-00279 : change string generated at string needed for thread string
  • ora-32550 : Replacement occured despite hint to the contrary
  • ora-30434 : refresh method must be one of FC?AN, not 'string'
  • ora-06433 : ssaio: LSEEK error, unable to seek to requested block.
  • ora-13296 : incorrect coordinate system specification
  • ora-10660 : Segment is a shared lob segment
  • ora-01088 : cannot shut down ORACLE while active processes exist
  • ora-08208 : ora_addr: cannot read from address file
  • ora-29382 : validation of pending area failed
  • ora-01542 : tablespace 'string' is offline, cannot allocate space in it
  • ora-29261 : bad argument
  • ora-22618 : attribute is a BAD NULL in the image handle
  • ora-19699 : cannot make copies with compression enabled
  • 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.