The Spotlight User Wizard has encountered an error. An error was reported for table "SoOBody" in connection "NNN".
The error is:
276/16 PLS-00904: insufficient privilege to access object PUBLIC.DBMS_SQL
276/10 PL/SQL: Statement ignored
277/34 PLS-00904: insufficient privilege to access object PUBLIC.DBMS_SQL
277/10 PL/SQL: Statement ignored
278/10 PLS-00904: insufficient privilege to access object PUBLIC.DBMS_SQL
278/10 PL/SQL: Statement ignored
279/10 PLS-00904: insufficient privilege to access object PUBLIC.DBMS_SQL
279/10 PL/SQL: Statement ignored
283/16 PLS-00904: insufficient privilege to access object PUBLIC.DBMS_SQL
283/10 PL/SQL: Statement ignored
284/16 PLS-00904: insufficient privilege to access object PUBLIC.DBMS_SQL
284/10 PL/SQL: Statement ignored
289/13 PLS-00904: insufficient privilege to access object PUBLIC.DBMS_SQL
289/13 PL/SQL: Statement ignored
290/13 PLS-00904: insufficient privilege to access object PUBLIC.DBMS_SQL
290/13 PL/SQL: Statement ignored
463/27 PLS-00904: insufficient privilege to access object PUBLIC.DBMS_SQL
463/27 PL/SQL: Item ignored
464/27 PLS-00904: insufficient privilege to access object PUBLIC.DBMS_SQL
464/27 PL/SQL: Item ignored
in table SooBody
You can use Toad to compile packages that were not compiled. One of them might be QUEST_SOO_PKG (Body) showing Invalid status.
you can run :
Select * from dba_objects
where object_name = 'DBMS_SQL'
If the package shows invalid:
grant execute on sys.dbms.sql to spotlight
(assuming your Spotlight's user name is spotlight)
