Security Differences Security Ineheritance Users in Groups Item Security Audit
Software Security Manager Features

© Defacto 2018

Contact us

Simplify Business Intelligence

Home

2ndRock

Home Software Download Purchase Software Support

SSRS Security Manager Feature List

Comparing Report Manager vs SSRS Security Manager.

The professional version has been released this has the same functionality as the enterprise version except it does not support forms authentication or SQL Azure Reporting

Feature

Report Manager

SSRS Security Manager



Standard

Professional

Enterprise

SSRS Version





SSRS 2000-  SSRS 2017

SQL Azure Reporting (SSRS Azure)

x

x

View All Item Security Differences





Show security in treeview highlighting differences

x

1 click change to inherit security

x

1 click change to remove inheritance

x

View Individual Item Security





View User/Group roles per Item

Compare user/group roles in grid

x

Show user/group roles and tasks in grid

x

Manage Security





1 click change to inherit security

x

1 click change to remove inheritance

x

Add user/group using current item as a template

x

Role Management





Add/delete/modify role

x#1

Add role using current role as a template

x#1

Visibility of roles by tasks

x#1

Compare roles side by side

x#1

System Role Management





Add/delete/modify role

x#1

x

Add role using current role as a template

x#1

x

Visibility of roles by tasks

x#1

x

Compare roles side by side

x#1

x

Add user/group to system role

x#1

x

Modify/delete user/group to system role

x#1,2

x

Audit- Snapshot of SSRS Security





Item Security by user/group and role

x

x

Roles to assigned tasks

x

x

System roles to  assigned tasks

x

x

System user/groups assigned to system roles

x

x






Notes


#1 Requires SQL Server Management Studio. SQL Server management Studio Express only supports database Engine instances not SSRS.

#2 Not possible in SQL Azure report manager see http://msdn.microsoft.com/en-us/library/windowsazure/hh403969.aspx for further details