Home » RDBMS Server » Performance Tuning » insufficient privileges when generating explain plan for a synonym  () 1 Vote
insufficient privileges when generating explain plan for a synonym [message #235847] Tue, 08 May 2007 02:48 Go to next message
win3vin
Messages: 35
Registered: April 2007
Location: Malaysia
Member

Hi

Need help. I have a user running explain plan but the user will receive a insufficient privileges message when generating a synonym of a view from another user. the user can generate plan for synonym of table from another user but not the view. Any idea?

other user is working fine.
Re: insufficient privileges when generating explain plan for a synonym [message #235861 is a reply to message #235847] Tue, 08 May 2007 03:31 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If a user has create synonym privilege he can't receive an insufficient privilege when he creates a synonym whatever is this synonym definition.
What is the relation between "user running explain plan" and "receive a insufficient privileges message when generating a synonym"?

Regards
Michel
Re: insufficient privileges when generating explain plan for a synonym [message #235866 is a reply to message #235847] Tue, 08 May 2007 03:39 Go to previous messageGo to next message
win3vin
Messages: 35
Registered: April 2007
Location: Malaysia
Member
hi

the view and the table belongs to user A, the user B created a synonym to query the view and table belongs to user A.

The User B can query the view and table using normal select statement, and can create explain plan of the TABLE but will receive the insufficient preivileges error when generating explain plan for the VIEW. Thanks man..
Re: insufficient privileges when generating explain plan for a synonym [message #235868 is a reply to message #235866] Tue, 08 May 2007 03:47 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Because he got his privileges through a role and not directly.
There is no relation with synonym.

Regards
Michel
icon14.gif  Re: insufficient privileges when generating explain plan for a synonym [message #235872 is a reply to message #235847] Tue, 08 May 2007 04:10 Go to previous message
win3vin
Messages: 35
Registered: April 2007
Location: Malaysia
Member
Got it. thanks man
Previous Topic: DATABASE DOWN WHEN MANY USERS LOG IN
Next Topic: Long Running SQL - Oracle
Goto Forum:
  


Current Time: Fri Dec 02 18:23:41 CST 2016

Total time taken to generate the page: 0.53544 seconds