Post reply

Role to just to view the reports from report manager?

  • September 28, 2011 at 2:42 pm

    #245609

    Hi,

    I given the the Browse permission to user Scott and he is able to view the reports. But he is also able to delete the reports which I don't want to do.

    So what is the role I have to give a user to just view the reports?

    Thanks

  • September 28, 2011 at 3:02 pm

    #1388114

    Browse can just read. Scott must be a member of another group that is a member of a more privileged role.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • September 29, 2011 at 10:31 am

    #1388499

    Thanks Jason,

    Please see the attached screen. I have granted the browse permission to abc\scott in Report Manager->Home->Properties page.

    Under Home page of Report Manger, we have 4 folders called Folder1, Folder2, Folder3, (each folder have different application reports) and Folder4 have Data Source.

    I need to grant browse permission to abc\scott only to Folder1 to view & run the reports and permission to Folder4 to view data source properties. Please advice what exactly I need to do to set up this?

    But with the current set up I have, abc\scott is able to view all 4 folders and can run the reports and he also can delete the folders and reports.

    And he is unable to view contents in folder4 (Data Source)

    Please advice..

  • September 29, 2011 at 10:35 am

    #1388503

    is this person a member of the builtin\administrators group?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • September 29, 2011 at 10:39 am

    #1388508

    No. It's not.

  • September 29, 2011 at 10:43 am

    #1388512

    That user must be. Browser only allows view access.

    http://msdn.microsoft.com/en-us/library/ms155804.aspx

    Check the builtin\administrators group on the local machine. That user is likely a member of a domain group that is a member of the builtin\administrators or he is directly added to builtin\administrators.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

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

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