ssrs new role assignment

In Reporting Services, role assignments determine access to stored items and to the report server itself. A role assignment has the following parts: A securable item for which you want to control access. Examples of securable items include folders, reports, and resources.

A role assignment is a security policy that determines a user's or group's permissions. Permissions decide whether the user or group can access or modify a specific report server item, or do a task. A role assignment consists of a single user or group account name and one or more role definitions.

A role assignment maps a group or user account to a predefined role that defines the tasks that can be done. It determines the types of tasks that a user does to a folder, report, model, or other content type. To create, modify, or delete role assignments, you use the SSRS web portal.

I think the best option you have is to create custom roles. To do so with SSRS 2008, you need to connect using SQL Server Management Studio, selecting the Reporting Services Server type. You will be able to manage roles from there. Here is a MSDN article that will help you.

Add New User Role in SSMS. Instead of using the default user roles, we can use the SQL Server Management Studio to create a new role as per our requirements. To do so, please open the SSMS and select the Server Type as Reporting Services. Don’t forget the credentials to log in to the Server.

Adding SSRS Users (new role…Well since Microsoft made it virtually impossible to add new users directly via SQL we are forced to use the Reporting Web Services. After just a few minutes of...

1. Use "Edit Item Security" for a report or folder. 2. Delete a User name from the Home folder Security page. 3. Add a new user using "New Role Assignment" The really weird thing is that some of these 3 actions work in some report folders. There is nothing I can see common between the ones that work and those that don't. Any ideas??

In SQL Server Reporting Services Native mode, a report server has a role of a standalone application server, that provides all viewing, processing, delivery, and management of reports and report models. This is the default mode for SSRS instances. To set up SSRS Native mode on your local machine follow the instructions below:

To create, modify, or delete roles, you can use SQL Server Management Studio. You can only delete roles that aren't in use. To assign users and groups to the roles that you create, use the SSRS web portal.

Object permissions must be granted at the database level while SSRS folder and report level permissions requires that a user be assigned to one or more SSRS roles. Several predefined roles exist and will suffice for much of your permission needs.