February 2, 2015 at 1:43 am
Hello,
I have a asp.net application which uses Active Directory for authentication, and adomd.net / C# for data access to SSAS (using MDX).
The issue is, we wish to switch to a SQL Server database for authentication, but wonder the following :
- is it a good practice to keep one Active Directory account using the EffectiveUserName property of the adomdconnection object, and then user only Roles to limit access to dimensions (geography dimensions for example) ?
ultimately, the goal would be to use part of this application as a REST API.
Thanks.
Oussama Dinia
.NET Solutions Architect
http://devmeetsbi.ghost.io/
http://www.devmeetsbi.io/catalog/3079
March 13, 2015 at 12:25 am
Hello,
The question I asked myself, was while building a course on adomd.net.
The solution I have found, is that The administrator of SSAS server can be the application pool windows user account (it has to be in a domain).
After that, we have the choice between Roles and/or EffectiveUserName for impersonation, in case we have users connecting individually to SSAS.
A link to the course is in my signature.
Regards,
Oussama Dinia
.NET Solutions Architect
http://devmeetsbi.ghost.io/
http://www.devmeetsbi.io/catalog/3079
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply