I have SSRS on SharePoint 2013 and SQL Server 2012.
I have need to limit access for certain AD users and groups for some figures on SSRS.
For example certain group have no access to Salary data of all employee of HR Dashboard, but all users would have rights to view Number of employee of HR Dashboard.
1) Is Security Role right functionality?
2) Is Kerberos mandatory in this scenario???
3) Where to limit access to dimention for certain AD group in practise? Any point for start.
- Edited by Kenny_I Wednesday, October 09, 2013 11:12 AM
2) Is Kerberos mandatory in this scenario??? - > Kerberos or NTLM is just authentication mode for making connection to each other and work like below:
Kerberos - > NTLM connection can be possible
NTLM--> Kerberos you can't make connection
You have only security for measures and dimension members in BISM Multidimensional(previously called SSAS) and BISM Tabular, implemented as roles. If you have the data in the SQL Server RDBMS you have no security like in the two BISM services.
Regarding BISM Tabular I am not sure that you can secure measures but dimension security is supported.
Kerberos is not mandatory in SharePoint 2013 but is mandatory in earlier versions.
Thanks for replies. I'm not sure if I understood the point.
My aim is to configure security roles in SSAS. I would like to highlight that SSRS is configured as SharePoint Integrated mode.
I would like to deny some of dimention from certain AD groups. Obviously this means that cube must know which user is accesing reports.
Do you mean that using Security roles in SharePoint 2010 requires Kerberos, but Kerberos is not required in SharePoint 2013?
- Edited by Kenny_I Wednesday, October 09, 2013 11:58 AM