August 27, 2009 at 7:38 am
Hi,
I have 10 reports running in SSRS. I gave permission to network users to browse to these reports. In Sql server, I would like to know all users whom I have authorized. It might be one of the tables in master?
August 27, 2009 at 8:30 am
How did you grant rights to the reports, via specific user or by AD group? If by group the best you can get without going out to AD is the groups and it is stored in ReportServer.dbo.Users.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 27, 2009 at 12:22 pm
Thank you for your answer. I gave access via AD.
In ReportServer.dbo.Users table, I see userid,sid,usertype,Authtype,username.
which table do I get the report name which is given access to users?
August 27, 2009 at 1:12 pm
How's PolicyID is generated in ReportServer.dbo.policies?
September 1, 2009 at 1:10 pm
Select newid()
September 1, 2009 at 1:44 pm
mya (8/27/2009)
Thank you for your answer. I gave access via AD.In ReportServer.dbo.Users table, I see userid,sid,usertype,Authtype,username.
which table do I get the report name which is given access to users?
SELECT Catalog.Path, Catalog.Name, Users.UserName
FROM Catalog INNER JOIN
PolicyUserRole ON Catalog.PolicyID = PolicyUserRole.PolicyID INNER JOIN
Users ON PolicyUserRole.UserID = Users.UserID
September 2, 2009 at 3:59 pm
Hi,
Have you given these rights through the SSRS web interface?
September 3, 2009 at 6:58 am
An easy alternative - depending on your set up - is to go to Report Manager, click on the report in question, view properties/security and it gives a listing of everyone who has access to the reports as well as their level of access.
September 3, 2009 at 2:23 pm
Hi
You could add the NT AUTHORITY\NETWORK SERVICE group
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply