I am using the 10.2.0.5 version of Grid Control. One of the databases being monitored is at 11.1.0.7. I want dbsnmp to be able to use the SQL_TUNING_ADVISOR. I have set this up and am successful using the advisor when the statement can be found under "Top Activity", but if the statment is no loger there, an "ORA-O1031" error is returned. The dbsnmp user cannot read the recommendations. If I temporarily give dbsnmp dba privileges, then it can read the recommendations. So it looks like an access problem on some view or table
I tried granting dbsnp "select any table", and also direct grants to the tables and views which start with v_$, dba_hist, wrh, and wri, but it still cannot read recommendations from statements not found under Top Activity. I also granted direct access to dbsnmp to SYSMAN's tables and views.