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 : 25-06-2017

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

  • ora-13200 : internal error [string] in spatial indexing.
  • ora-12209 : TNS:encountered uninitialized global
  • ora-36224 : (XSLPDSC05) workspace object is not a loop dimension
  • ora-09856 : smpalo: vm_allocate error while allocating pga.
  • ora-01985 : cannot create user as LICENSE_MAX_USERS parameter exceeded
  • ora-06519 : active autonomous transaction detected and rolled back
  • ora-19575 : expected string blocks in file string, found string
  • ora-00060 : deadlock detected while waiting for resource
  • ora-06253 : NETNTT: cannot read arguments from address file
  • ora-13911 : Threshold not found
  • ora-24036 : invalid SORT_ORDER column string specified for queue table
  • ora-32631 : illegal use of objects in MODEL
  • ora-15125 : ASM file name 'string' contains an invalid template name
  • ora-36978 : (XSRELGID01) workspace object must be a self-relation.
  • ora-25187 : specified exceptions table form incorrect
  • ora-02705 : osnpol: polling of communication channel failed
  • ora-23622 : Operation string.string.string is in progress.
  • ora-06254 : NETNTT: cannot share connection to cube
  • ora-15079 : ASM file is closed
  • ora-12034 : materialized view log on "string"."string" younger than last refresh
  • ora-30566 : Index maintainence clause not allowed for this command
  • ora-10914 : invalid TABLESPACE GROUP clause
  • ora-12324 : cannot use the ROM: link type on a private database link
  • ora-22887 : type of REF column is not the same as that of its scoped table
  • ora-30102 : 'string' is not in the legal range for 'string'
  • ora-28545 : error diagnosed by Net8 when connecting to an agent
  • ora-01500 : failure in getting date/time
  • ora-19750 : change tracking file: 'string'
  • ora-01900 : LOGFILE keyword expected
  • ora-31163 : element or attribute "string" has invalid attribute value "string" (should be "string")
  • 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.