priviledge error explain plan

[ayushsingh]

Hi all
While explaining i am getting this error please help.

SQL> set autotrace on
SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabled
SP2-0611: Error enabling STATISTICS report

and

SQL> set autotrace traceonly explain
SQL> select * from cat;

Execution Plan
----------------------------------------------------------
ERROR:
ORA-01039: insufficient privileges on underlying objects of the view


SP2-0612: Error generating AUTOTRACE EXPLAIN report
SQL>

[jovery]

You have not given your RDBMS version or platform so I will assume 8i on Unix.

Logon the SQL*PLUS as USER SYS
SQL> CONNECT sys/password

Execute the plustrce.sql script 
SQL> @$ORACLE_HOME/sqlplus/admin/plustrce.sql

Grant Role PLUSTRACE to User
SQL> GRANT plustrace TO username;

Logon  as the user requiring the usage of AUTOTRACE
SQL> CONNECT username/password

Create an explain plan table, Execute the utlxplan.sql script
SQL> @$ORACLE_HOME/rdbms/admin/utlxplan.sql

This should solve your problem.

regards

[ayushsingh]

Thanks for the reply
after doing the above I get these errors

SQL> set autotrace on

SP2-0619: Error while connecting
SP2-0611: Error enabling STATISTICS report
SQL> set autotrace traceonly explain
SQL> select * from cat;

Execution Plan
----------------------------------------------------------
ERROR:
ORA-01039: insufficient privileges on underlying objects of the view


SP2-0612: Error generating AUTOTRACE EXPLAIN report
SQL>

Thanks