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 : 23-08-2017
ORA-13842

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

  • ora-03209 : DBMS_ADMIN_PACKAGE invalid file/block specification
  • ora-24407 : connection pool already exists
  • ora-19224 : XP0004 - XQuery static type mismatch: expected - string got - string
  • ora-40254 : priors cannot be specified for one-class models
  • ora-24280 : invalid input value for parameter string
  • ora-07592 : sspgprv: Error obtaining required privileges
  • ora-02040 : remote database string does not support two-phase commit
  • ora-38746 : error occurred while restoring data block (file# string, block# string)
  • ora-24400 : error occured while creating connections in the pool
  • ora-38750 : FLASHBACK DATABASE may not be performed using a dispatcher.
  • ora-02220 : invalid MINEXTENTS storage option value
  • ora-36628 : (XSAGMODLIST03) MODEL workspace object could not be added to AGGMAP workspace object.
  • ora-02468 : Constant or system variable wrongly specified in expression
  • ora-13829 : SQL profile named string already exists
  • ora-39314 : call to DBMS_SCHEMA_COPY.SYNC_CODE is not legal
  • ora-09859 : sfngat: the input file name is not in the autobackup OMF format
  • ora-37182 : you may only specify one dimension to partition
  • ora-24812 : character set conversion to or from UCS2 failed
  • ora-02800 : Requests timed out
  • ora-10661 : Invalid option specified
  • ora-01255 : cannot shutdown - file string in recovery manager backup
  • ora-34001 : (MODCOMP14) Concat leaf dimension workspace object already is used in a DIMENSION statement, either explicitly or as a leaf of another concat dimension.
  • ora-12830 : Must COMMIT or ROLLBACK after executing parallel INSERT/UPDATE/DELETE
  • ora-12820 : invalid value for DEGREE
  • ora-28512 : cannot get data dictionary translations from string
  • ora-22866 : default character set is of varying width
  • ora-40301 : invalid cost matrix specification
  • ora-00220 : control file not mounted by first instance, check alert log for more info
  • ora-06500 : PL/SQL: storage error
  • ora-19706 : invalid SCN
  • 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.