October 7, 2014 at 8:58 pm
Hi,
I have a user wom needs to view the standard reports made available through the right-click -> Reports -> Standard Reports menu, however when they right-click the Reports option is missing.
I have granted the user VIEW ANY DEFINITION and VIEW SERVER STATE, but this has not enable/made visible the option.
Does anyone know which permission is required to be able to see the reports option?
Thanks,
October 8, 2014 at 12:13 am
If I remember correctly those menu links should be there even when user has not enough permissions. Report will show some error on that situation.
October 8, 2014 at 1:42 am
Ville-Pekka Vahteala (10/8/2014)
If I remember correctly those menu links should be there even when user has not enough permissions. Report will show some error on that situation.
Indeed, the reports should be available. You just get an error if you don't have SELECT permissions on the underlying DMVs.
Does the user have the following DLL?
Microsoft.SqlServer.Management.Reports.dll
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 8, 2014 at 1:46 am
Thanks for the reply.
That's interesting, if that's the case I think it might come down to the SSMS version. The user I'm supporting might be using SSMS express?
October 8, 2014 at 1:54 am
ReamerXXVI (10/8/2014)
Thanks for the reply.That's interesting, if that's the case I think it might come down to the SSMS version. The user I'm supporting might be using SSMS express?
That might be possible. I haven't found an official source to confirm this, but on several fora I found people stating SSMS Express doesn't have the reports.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply