This Scripts will check for public access to extended Stored procedures in sql server 2000 and 2005.
Securing Reporting Services Reports
Learn how you can get the userid of someone connected to Reporting Services and use that information to determine if they can view the report.
2017-12-22 (first published: 2010-05-18)
8,239 reads