Explain Plan - What privileges needed ?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Explain Plan - What privileges needed ?

  1. #1
    Join Date
    Oct 2000
    Location
    Dallas:TX:USA
    Posts
    407
    My developers want to see the explain plan of the their SQLs running (for debugging purposes) thru DBA-Studio

    What roles/privileges I need to give them ?

    If I give them DBA role, they will be able to view as well as kill anybody's sessions.
    I am wondering if there is a set of privileges that will give them view the running SQLs and the associated Explain plan but may not give them power others' sessions.

    They can't run the SQL on SQL/Plus (to see the explain plan)because SQLs are gererated dynamically by the application.

    I know there are ways to write procedures to accomplish this but I am interested to know who all of you tackle this situation.

    Thanks,
    - Rajeev
    Rajeev Suri

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    As long as they meet the requirements like having a plan table they should be able to execute the plans....


    http://www.oradoc.com/ora816/server....13_exp.htm#822

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


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