View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0000494Database Workbench v4Microsoft SQL Server Modulepublic2012-12-19 16:402013-04-24 12:47
ReporterJeroen Pluimers Assigned ToMartijn Tonies  
PrioritynormalSeverityblockReproducibilityalways
Status closedResolutionfixed 
Platformx86OSWindowsOS Version7
Fixed in Version4.4.0 
Summary0000494: SQL Server 2008 back-end: if a user has no "Execute Query Plan" permissions, DBWB does not show query results. See screen shot.
DescriptionSQL Server 2008 back-end: if a user has no "Execute Query Plan" permissions, DBWB does not show query results. See screen shot.
Steps To Reproduceperform a query against SQL Server 2008 where the user does not have execute query plan permissions.
TagsNo tags attached.
DBMS & Version

Activities

Jeroen Pluimers

2012-12-19 16:40

reporter  

20121219-DBWB-v4.3.2-Pro-SQL-2008-Server-query-does-not-work-if-you-do-not-have-query-plan-permissions.png (96,509 bytes)   
20121219-DBWB-v4.3.2-Pro-SQL-2008-Server-query-does-not-work-if-you-do-not-have-query-plan-permissions.png (96,509 bytes)   

Jeroen Pluimers

2012-12-20 13:51

reporter   ~0000156

Enable/Disable showplan:

http://blog.sqlauthority.com/2010/01/05/sql-server-fix-error-262-showplan-permission-denied-in-database/

http://msdn.microsoft.com/en-us/library/ms175117(v=sql.105).aspx

Issue History

Date Modified Username Field Change
2012-12-19 16:40 Jeroen Pluimers New Issue
2012-12-19 16:40 Jeroen Pluimers File Added: 20121219-DBWB-v4.3.2-Pro-SQL-2008-Server-query-does-not-work-if-you-do-not-have-query-plan-permissions.png
2012-12-20 13:50 Martijn Tonies Status new => acknowledged
2012-12-20 13:51 Jeroen Pluimers Note Added: 0000156
2013-01-14 19:47 Martijn Tonies Assigned To => Martijn Tonies
2013-01-14 19:47 Martijn Tonies Status acknowledged => assigned
2013-01-22 14:28 Martijn Tonies Status assigned => resolved
2013-01-22 14:28 Martijn Tonies Fixed in Version => 4.4.0
2013-01-22 14:28 Martijn Tonies Resolution open => fixed
2013-04-24 12:47 Martijn Tonies Status resolved => closed