April 3, 2017 at 9:25 am
Is there a way that you can extract all email subscription in SSRS without admin privilege?
April 3, 2017 at 10:41 am
lhynlen - Monday, April 3, 2017 9:25 AMIs there a way that you can extract all email subscription in SSRS without admin privilege?
Yes. What permissions are needed would depend on how you are going to go about this.
A user could have select or execute permissions on just the tables or stored procedures needed.
Sue
April 3, 2017 at 10:54 am
Thanks for your response. How can i implement this? I only have permission to view reports in a SharePoint library with the data source specified. Where should i run a script to extract the data in the server? Can i do it in Report Builder?
April 3, 2017 at 11:10 am
lhynlen - Monday, April 3, 2017 10:54 AMThanks for your response. How can i implement this? I only have permission to view reports in a SharePoint library with the data source specified. Where should i run a script to extract the data in the server? Can i do it in Report Builder?
No. You wouldn't have direct access to query any of the tables or execute any stored procedures in the Catalog (report server databases). Your access is just what you said - the reports and the specific data sources. It's something you should work out with the DBAs for the Report Server so how you do it really depends on whatever the access policies are for your company. I would guess based on what access you have now would be to look at writing a Powershell script or app of some sort that accesses the SOAP API to get the information you need.It may be worth bringing that up with the admins of the systems to see if that would be allowed. Accessing report properties and related info in the report server databases is only supported if going through the SOAP API.
Sue
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply