Post reply

Folder Permissions

  • June 14, 2012 at 1:26 pm

    #262405

    Is there a script I can run to find out who has access to a report folder or a particular report?

  • June 15, 2012 at 2:01 am

    #1501434

    This should get you what you want.

    SELECT

    C.Path,

    U.UserName

    FROM

    Catalog C

    INNER JOIN

    PolicyUserRole PUR

    ON

    C.PolicyID = PUR.PolicyID

    INNER JOIN

    Users U

    ON

    PUR.UserID = U.UserID

  • June 15, 2012 at 12:28 pm

    #1501841

    Thank you.

  • June 18, 2012 at 3:21 pm

    #1502480

    I can see the groups, but active directory handles the server permissions. Ever hear of a way to get the AD user names who have access to the report folders? I am just trying to figure out a way to handle who has permissions to what folders, without having to manually keep a log.

  • June 20, 2012 at 2:30 am

    #1503271

    The only way would be to loop it into a xp_logininfo call to query the members of the groups, or into a LDAP query which goes and looks up in AD the members.

  • June 20, 2012 at 6:57 am

    #1503374

    I will give those a try. Thank you for the replies.

Viewing 6 posts - 1 through 5 (of 5 total)

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