Post reply

Only Report Deployment access to reporting services

  • March 9, 2009 at 12:50 pm

    #201220

    Hello,

    I have one user who needs access to reporting services with deployment right. I want to give a user only report deployment access without adding them on Report admin group to the reporting database.

    If I add users as a “RS Execution” database role then, can he able to deploy report to the reporting services? I also add this user with “content manager” role to the folder as well as add as a “System user” role from Report Manager (Site setting).

    Please see attached screenshot for this

    In past, I gave access to user like that but I want to know is it this is a correct way to do or not?

    Thanks,

  • March 10, 2009 at 11:20 am

    #956965

    The content manager role is actually higher than you need but the person cannot be DataReader because you can use shared datasource with one DBO permission in the database used as datasource. So you need to give the person publisher and DDL admin or DBO because the limited permissions you have selected may be enough for your users but not the person who will deploy. This happened in my team when we connected to the deployment folder it was readonly so you need to use these permissions to connect to the deployment folder. Check below for the SSRS permissions so you can choose based on your needs.

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

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

    Kind regards,
    Gift Peddie

  • March 10, 2009 at 12:48 pm

    #957016

    Thanks for your reply. I will let you know...

  • March 19, 2009 at 7:22 am

    #962660

    Works fine...

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

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