Post reply

Hiding the Report based on User

  • January 31, 2012 at 6:36 am

    #250428

    Hi,

    On my report manager I have 4 reports deployed (SQL SERVER 2008 R2).

    Say there are 2 users U1 & U2.

    U1 should be able to view all the reports R1, R2, R3, R4.

    Whereas U2 should be able to view only R1 & R2. The reports R3 & R4 should be hidden. How can I hide the reports R3 & R4 for U2.

    Regards,

    Nithin

  • January 31, 2012 at 8:00 am

    #1440664

    You can do this as an administrator of the site. Go to the report you want hidden and alter its security to not inherit parent security. Then only add users to it that should have access.

    Jared
    CE - Microsoft

  • January 31, 2012 at 8:11 am

    #1440675

    Thank you :-):-):-):-):-) Jared once again :-):-):-):-)

    SQLKnowItAll (1/31/2012)

    You can do this as an administrator of the site. Go to the report you want hidden and alter its security to not inherit parent security. Then only add users to it that should have access.

Viewing 3 posts - 1 through 2 (of 2 total)

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