OLAP Security using C# to specific user

Question

Hello Friends Hope you doing good I stuck in one solution please help me out I have one OLAP script and i'm executing it on analysis server. But i want to provide security that the OLAP database which will create using script only have access to specific user that i pass through c#. i pass 3 data to sql server analysis sevice - script - DB_Name - User_Details DB create and only have access to user present in User details i want to create all programatically in C# thanks in advanced

Suthish Nair · Answer

You can try Using EXECUTE AS http://dataeducation.com/blog/basic-impersonation-using-execute-as http://stackoverflow.com/questions/13037863/clarification-as-to-why-execute-as-user-login-is-not-returning-the-expected-resu https://msdn.microsoft.com/en-us/library/ms181362.aspx