priviledge error explain plan
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: priviledge error explain plan

Hybrid View

  1. #1
    Join Date
    Dec 2002
    Posts
    62

    priviledge error explain plan

    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>

  2. #2
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    You have not given your RDBMS version or platform so I will assume 8i on Unix.

    Code:
    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
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  3. #3
    Join Date
    Dec 2002
    Posts
    62
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width