where to look up security at the reportserver.table ?

[stanja]

Hi ,

Is there a possibilty to qry the security of each report.
I want to see for a particular user which credentials he has on which reports in order to change/delete these by using a qry instead of open 1 by 1 the security at the reporting site.

tx
regards
Steven

 

[bburnell]

The best way to do it is to go on the actual server and log in to the "Reporting Services" in SQL Server Management Studio. Under there, go to home and then find your report. Right click on the report you are interested in seeing the security for and click the "Permissions" page. I don't think it is possible to delete/add with an SQL query, but I could be wrong.

Good luck!
~Brett

--------------------------
Web/.net Programmer & DBA
Central PA