|
|
|
|
|
|
| Re: Execution plan privileges [message #342654 is a reply to message #342650] |
Sat, 23 August 2008 11:20   |
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
|
Senior Member |
|
|
i got the solution for my issue.
The reason y the user (SCOTT) was not able to create a execution plan for the query is that the user had only 'select' privilege on PLAN TABLE.
use DBA_TAB_PRIVS view to find out users having privileges on tables.
it seems the user must have both the 'select' as well as 'insert' privilege on that table in order to examine execution plan for the query.
The solution for this issue is that:
I granted the 'INSERT' privilege for the same (PLAN TABLE') and thus it worked.
'grant insert on plan_table to user(SCOTT)'
Regards,
Balaji
[Updated on: Sat, 23 August 2008 11:22] Report message to a moderator |
|
|
|
|
|
|
|
| Re: Execution plan privileges [message #342688 is a reply to message #342685] |
Sun, 24 August 2008 02:34 |
 |
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
If you create a private plan_table you can't have a privilege problem this is what I said and I precise the script, even if you know, because this may be useful for readers (and you are not the lone one, anyway).
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
