Re: Show execution plan

Nancy Lytle (word_diva@xxxxxxxxxxx) writes:
How do I grant a user the ability to see query execution plans, currently
the developer who wants the permission, has dataread permission on the
database in question but gets an error message when he tries to view an
execution plan, saying he doesn't have permissions.

I tried
GRANT VIEW DEFINITION ON SCHEMA::dbo TO [User] but that didn't work.

I don't know how often I see "gets an error message", but people never
include the error message. It is as if it was digital OK, or NOT OK.
But actually: error messages include information, and it can help to
read them. In this particular case, you I expect you got something like:

Msg 262, Level 14, State 4, Line 1
SHOWPLAN permission denied in database 'Northwind'.

From this one could guess that this helps:

GRANT SHOWPLAN TO developeruser

And indeed, it does.

--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.

Relevant Pages

  • Re: Access wont open
    ... The exact error message is: ... It is already opened exclusively by another user, or you need permission to view its data. ... > database open in another window? ... > I've used the controls to setup the connection string, adaptor, dataset. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Issue with path / permissions for linked table
    ... Allen Browne - Microsoft MVP. ... If they don't have permission to create a file, ... > to use this shared database, they cannot access the linked tables. ... the users started getting an error message "The Microsoft Jet ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Problem with database connection
    ... The database attached to the web application was a read-only one. ... I did not find anything named Change Permission. ... The error message I quoted earlier was incorrect.The correct error message ... > account permissions for the folder containing the file - the account should ...
    (microsoft.public.inetserver.asp.db)
  • Outlook error messages
    ... This is the Error Message: ... >exist, you may not have permission to open it, or it may ... >Properties to check your permissions for the folder. ... >error occurred in the shortcuts file. ...
    (microsoft.public.outlook)
  • cant set scheduled tasks
    ... get an error message - access denied - do not have permission to perform ... "This written advice was not intended or written to be used, ... be used by any taxpayer, for the purpose of avoiding penalties that may be ...
    (microsoft.public.windowsxp.setup_deployment)