Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSRS Logins & Object Access Report Expand / Collapse
Author
Message
Posted Wednesday, September 3, 2008 7:37 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, February 11, 2014 7:25 AM
Points: 450, Visits: 481
Hi All,

I am trying to create a SP to query the ReportServerDB as we are developing a full SSRS system. Part of this is to apply security, of which a policy has been agreed and will be rolled out. But one action/item to fall out of this is that in each folder we create a SSRS Report is to exist, which when the user opens/executes will use there windows user name as a variable and detail/report on the SSRS Role(s) that they have been assigned along with all the objects (specifically Reports only) and whether they have access to the report or not.

But i have no idea how SSRS Db is structured, I know that the security/setup is stored in the DB but not how to get what I am after Please help!!!

Post #562992
Posted Wednesday, September 3, 2008 7:57 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, August 10, 2010 5:07 AM
Points: 2,732, Visits: 23,078
Querying the database directly is not a good idea. Use the web services made public through the report server. MS may (and does) change the database structure you are planning on coding against. You will find yourself having to re-code during RS upgrades.
Post #563007
Posted Wednesday, September 3, 2008 10:20 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, February 11, 2014 7:25 AM
Points: 450, Visits: 481
Ideally I'm after a report for use with the Report Services, essentially a report which summaries the users with access to each of our reports on SSRS. As if a user doesn't have the rights to see a report, they use directory report to find out who does to allocate access for them.
Post #563175
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse