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: Should Derived Classes Provide Custom Exception?
    ... The reason I say only provide custom exceptions if you are using a framework ... developer and providing developers with erros is a good thing. ... Update to the database failed, all he wants to know then is that it failed ... debugging than anything even the actual error message sometimes. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: 2007 wont open older format database
    ... The database is a 2000 format ... (which is overridden by using that shortcut with the secure workgroup command ... permission if the db is secure. ... Find out what the actual error message is when she tries to open the db.. ...
    (comp.databases.ms-access)
  • 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)