Search code examples
securityssas

MSOLAP Connection String : Is is possible to access Cube as a particular user

When Browsing an MS OLAP cube in SQL Server Management Studio I'm able to click on the change user button to change the user that I view the cube as. This let me test security access to various parts of the data.

enter image description here

I was wondering if it's possible to do this in the connection string also? As far as I understand it I can change the Roles property in the connection string, but as the data is locked from particular person's perspective this doesn't help. Also the cube uses windows security so a specific user and password combo aren't going to help either.

Solution

  • Yes, through the following property in your connection string:

    EffectiveUserName=DOMAIN\UserName

    This will only work if you're an SSAS administrator.