ORA-13842: no SELECT privilege on DBA_SQL_PROFILES

Cause : A user has tried to perform an operation that requires SELECT privileges on the DBA_SQL_PROFILES view.

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

Either perform the operation as another user or get the privilege

update : 30-04-2017

ORA-13842 - no SELECT privilege on DBA_SQL_PROFILES
ORA-13842 - no SELECT privilege on DBA_SQL_PROFILES

  • ora-26519 : no memory available to allocate
  • ora-02055 : distributed update operation failed; rollback required
  • ora-24409 : client cannot understand the object
  • ora-27002 : function called with invalid device structure
  • ora-01862 : the numeric value does not match the length of the format item
  • ora-16763 : redo transport service for a standby database is online
  • ora-01487 : packed decimal number too large for supplied buffer
  • ora-09820 : Conversion of class string to numeric representation failed.
  • ora-16952 : Failed to bind this SQL statement.
  • ora-29538 : Java not installed
  • ora-13622 : invalid recommendation annotation
  • ora-24908 : invalid recipient presentation attribute
  • ora-16752 : resource guard could not mount standby database
  • ora-01277 : file 'string' already exists
  • ora-14133 : ALTER TABLE MOVE cannot be combined with other operations
  • ora-23502 : valid directory for offline instatiation is not specified
  • ora-23452 : flavor string of object group "string"."string" is already published
  • ora-19721 : Cannot find datafile with absolute file number string in tablespace string
  • ora-31686 : error creating worker processes
  • ora-27230 : OS system call failure
  • ora-01426 : numeric overflow
  • ora-30930 : NOCYCLE keyword is required with CONNECT_BY_ISCYCLE pseudocolumn
  • ora-39150 : bad flashback time
  • ora-32150 : Cannot perform operation on a null timestamp
  • ora-16814 : incorrect redo transport setting for AlternateLocation for standby database
  • ora-14073 : bootstrap table or cluster may not be truncated
  • ora-13376 : invalid type name specified for layer_gtype parameter
  • ora-01588 : must use RESETLOGS option for database open
  • ora-39133 : object type "string"."string" already exists with different typeid
  • ora-07391 : sftopn: fopen error, unable to open text file.
  • 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.