none
Report builder RRS feed

  • Question

  • Is there a way that I can grant for users to use report builder without making them a built admin?
    Saturday, May 9, 2009 1:55 AM

Answers

  • Are you using Report Builder 1.0 or Report Builder 2.0? What version of SSRS - 2005 or 2008? In either case, users do not need to be in an admin role. The following role membership will provide sufficient permissions: Content Manager or Publisher - to author, publish & view reports with RB 2.0 Report Builder - to author, publish & view reports with RB 1.0
    Paul Turley [Hitachi Consulting] SQLServerBIBlog.com
    • Marked as answer by Gess Man Monday, May 11, 2009 3:21 PM
    Saturday, May 9, 2009 4:40 AM
    Moderator
  • Are you using Report Builder 1.0 or Report Builder 2.0? What version of SSRS - 2005 or 2008? In either case, users do not need to be in an admin role. The following role membership will provide sufficient permissions: Content Manager or Publisher - to author, publish & view reports with RB 2.0 Report Builder - to author, publish & view reports with RB 1.0
    Paul Turley [Hitachi Consulting] SQLServerBIBlog.com
    • Marked as answer by Gess Man Monday, May 11, 2009 3:21 PM
    Saturday, May 9, 2009 4:40 AM
    Moderator

All replies

  • Are you using Report Builder 1.0 or Report Builder 2.0? What version of SSRS - 2005 or 2008? In either case, users do not need to be in an admin role. The following role membership will provide sufficient permissions: Content Manager or Publisher - to author, publish & view reports with RB 2.0 Report Builder - to author, publish & view reports with RB 1.0
    Paul Turley [Hitachi Consulting] SQLServerBIBlog.com
    • Marked as answer by Gess Man Monday, May 11, 2009 3:21 PM
    Saturday, May 9, 2009 4:40 AM
    Moderator
  • Are you using Report Builder 1.0 or Report Builder 2.0? What version of SSRS - 2005 or 2008? In either case, users do not need to be in an admin role. The following role membership will provide sufficient permissions: Content Manager or Publisher - to author, publish & view reports with RB 2.0 Report Builder - to author, publish & view reports with RB 1.0
    Paul Turley [Hitachi Consulting] SQLServerBIBlog.com
    • Marked as answer by Gess Man Monday, May 11, 2009 3:21 PM
    Saturday, May 9, 2009 4:40 AM
    Moderator
  • Hi,

     

    You don’t need to grant built admin for the users. To use Report Builder, you just need to grant a system role assignment that includes the "Execute report definitions" task.

     

    Create a system-level role assignment that includes the System User role (the default setting includes the "Execute report definitions" task), or create a system-level role assignment that includes new role with "Execute report definitions" task. A system-level role assignment is necessary for granting access to Report Builder. After that, the users can see the Report Builder button in Report Manager. Also, create a role assignment under Home that includes the Report Builder role. An item-level role assignment is necessary for granting access to report models.

     

    For more information, see:

    http://technet.microsoft.com/en-us/library/ms365173(SQL.90).aspx

    http://technet.microsoft.com/en-us/library/ms159667(SQL.90).aspx

     

    Hope this helps.

    Raymond

    Monday, May 11, 2009 7:54 AM
    Moderator