Loading

OLAP Security using C# to specific user

Swapnil Nandane

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

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Suthish Nair10y ago
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