Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Creating groups Expand / Collapse
Author
Message
Posted Tuesday, October 22, 2013 9:16 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, February 24, 2014 11:06 AM
Points: 109, Visits: 215
Hello,

I am new to SSRS and would like a bit of guidance. I would like to create specific Groups or Roles that have certain privileges. So let's say I have the following groups... "Help Desk", "Call Center", "IT". I would like to be able to use windows authentication within these groups to execute certain reports. I am going to have subscriptions set up for all users. I am not sure how to set something like this up. Any help would be greatly appreciated.

Thanks
Post #1507212
Posted Wednesday, October 23, 2013 5:22 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 3:54 AM
Points: 241, Visits: 2,680
You will need to create these groups as either Active Directory or Local Server groups and then assign your users as members of these groups. Once you create the groups you assign the users permission to specific folder and to certain roles for each folder (you can customize the roles.. take a look at http://www.mssqltips.com/sqlservertip/3064/sql-server-reporting-services-report-builder-2012-security/ or http://technet.microsoft.com/en-us/library/ms155843.aspx) .
Post #1507547
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse