Post reply

Reporting on Security Permissions

  • May 24, 2005 at 3:49 pm

    #167048

    Hello,

    We are in the middle of setting up our SSRS server and building our folder structure and applying NT Groups and Roles to the various folders.  However, I have found no good way of "seeing" the big picture in terms of who has access to what.  Does anyone know of a tool or script or something that can tell me this?  For example, I would like to see a list of folders and the NT Groups/Users assigned to the folders and what role(s) the Group/User has.

    Hopefully SRS 2005 will have this ability built-in.

    Thanks!

  • May 25, 2005 at 6:43 am

    #560926

    Check out the BOL, if you look up the method ReportingServices.GetPolicies, there's sample code (vb.net and c#) that will produce what you're looking for.

    With minor changes you could take the vb.net and create an *.rss file that could then be passed to rs.exe (ie it's then a script rather than having to write a commandline/winforms/webforms app).

    HTH,

    Steve.

  • May 25, 2005 at 6:45 am

    #560927

    Thanks Steve.  I will check into this.

  • May 25, 2005 at 10:51 am

    #561031

    try using the reportserver database for policy information.

    join tables like catalog, policy,roles,PolicyUserRole

     

    Ruud

  • May 25, 2005 at 11:23 am

    #561040

    and table users of course

     

    Ruud

    Ruud

  • June 22, 2005 at 10:15 am

    #567552

    can you provide a sql script? Thanks

  • June 22, 2005 at 12:52 pm

    #567628

    Hi  there,

    I posted 2 scripts under "Miscellaneous" on this site for metadata Reportserver and monitoring and logging Reportserver.

    I don't have the illusions that these scrips are complete but it's a startpoint.

    Ruud

     

    Ruud

  • June 22, 2005 at 1:43 pm

    #567659

    Thanks Ruud.

  • June 22, 2005 at 2:15 pm

    #567675

    Ruud,

    Do you happen to know what the different reportserver.dbo.catalog.Type values are for?

  • June 22, 2005 at 2:55 pm

    #567702

    the types I know of are:

    type

    1 = map or folder

    2 = report

    4 = linked report

    5 = datasource

     

     

    (did not figure out yet what type 3 is)

    Ruud

    Ruud

  • June 22, 2005 at 2:56 pm

    #567703

    the types I know of are:

    type

    1 = map or folder

    2 = report

    4 = linked report

    5 = datasource

     

     

    (did not figure out yet what type 3 is)

    Ruud

    Ruud

  • July 4, 2005 at 4:48 am

    #570613

    Ruud, we think type 3 is an image

  • July 5, 2005 at 10:10 am

    #570914

    that makes sense, we don't use images in our reports.

     

    thanx

    Ruud

  • September 11, 2007 at 3:58 pm

    #732928

    3 is a graphic image

  • September 11, 2007 at 7:39 pm

    #732967

    Technically 3 is a 'Resource'

    http://msdn2.microsoft.com/en-us/library/microsoft.wssux.reportingserviceswebservice.rsmanagementservice2005.catalogitem.type.aspx

    Looks like the doco maybe had 5 & 6 reversed?  Unknown = 0?

    Steve.

Viewing 15 posts - 1 through 15 (of 15 total)

You must be logged in to reply to this topic. Login to reply