version 11.2.0.4.0
OS Solaris x64
Toad 9.0
Hi, I am trying to give a new user privleges to view explain plan. for that I did the following
grant select_catalog_role to <USERNAME>;
grant execute on sys.dbms_xplan_type to <USERNAME>;
grant execute on sys.dbms_xplan_type_table to <USERNAME>;
It did not work, and then I granted the select privelege on the already existing plan table to the new user.
Grant select on sys.plan_table to <USERNAME>;
create synonym plan_table for sys.plan_table
still It did not work, I got the error "ORA-01031: insufficient privileges" when trying to view explain plan.
I even tried to create a new plan table in that new user schema by executing the utlxplan.sql, but I am getting an error message saying that the table already exisit.
can someone please help me out where I am going wrong.
Thank You