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

Answer 1

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