Post reply

Report Manager Security Permission Issue

  • May 28, 2013 at 12:32 pm

    #275805

    I have a folder in SSRS Report Manager that a user created for testing reports. The issue is the user only gave herself permission to the folder and she only gave herself Browser rights. How can she go back and give herself Content Manager permission so she can delete/update the folder?

  • May 30, 2013 at 12:22 pm

    #1619808

    bump

  • May 31, 2013 at 7:38 am

    #1620073

    what if you go to the folder settings and try to revert to parent security? Could you just recreate the folder or you essentially locked out of changing it?

  • June 3, 2013 at 8:21 am

    #1620576

    Since she is the only one that can even get to the folder and she only has Browser security, she can't make any changes to the Security settings.

  • June 3, 2013 at 10:06 am

    #1620638

    I'm not sure how comfortable you are with this but you might be able to edit her access in the tables. I'm not sure it's something I would do without testing but it you look for her in the Users table you can get her GUID.

    SELECT * FROM [Users] Where UserName = 'Steven.Howes'

    My GUID happened to be 8AD84ECF-559C-4BD5-9B90-5D68CA4DEADF

    Then look for Her in the PolicyUserRole Table

    SELECT * FROM [PolicyUserRole] where UserID = '8AD84ECF-559C-4BD5-9B90-5D68CA4DEADF'

    From there you can see her Role.

    If you query the Roles table you can then get the role GUID for the Content manager and update the PolicyUesrRole table with this GUID.

    I haven't tried this personally, and I wouldn't do this without testing in on a test user and taking at least 3 backups.

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

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