Post reply

Giving non sa users select access to cubes?

  • March 9, 2015 at 9:15 am

    #295030

    Hi All,

    I have been searching high and low and cant find how to solve this problem i have with ssas permissions. We have a couple cubes we want to allow non sa users to be able to query using mdx. However they never seem to have permission no matter what we try. Has someone experienced or even seen the same problem and a solution?

    Thanks in advance!

  • March 9, 2015 at 9:18 am

    #1782581

    BTB (3/9/2015)

    Hi All,

    I have been searching high and low and cant find how to solve this problem i have with ssas permissions. We have a couple cubes we want to allow non sa users to be able to query using mdx. However they never seem to have permission no matter what we try. Has someone experienced or even seen the same problem and a solution?

    Thanks in advance!

    The role-based security within SSAS works pretty well, and I haven't seen what you are describing. Could you please post more information (i.e. screen grabs or details of your roles, permissions etc.)

  • March 9, 2015 at 9:30 am

    #1782587

    Sorry for lack of detail. We have never allowed any user to query a cube using a select (openrowset in the users case). when i run i get results based on their query but that is because i am sysadmin. When they try to run they get the error attached. Is there a document or site i can view on how to give non sa users permission to query?

  • March 9, 2015 at 9:59 am

    #1782606

    BTB (3/9/2015)

    Sorry for lack of detail. We have never allowed any user to query a cube using a select (openrowset in the users case). when i run i get results based on their query but that is because i am sysadmin. When they try to run they get the error attached. Is there a document or site i can view on how to give non sa users permission to query?

    Depending on the configuration during installation, local admins will be local admins in your SSAS instance also. SSAS security is administered separately...so the question is: Do your users have read permissions on the cubes in the SSAS instance?

  • March 9, 2015 at 10:00 am

    #1782608

    And a follow-up question: Why are you using OpenRowset?

    Users should be able to connect directly to the SSAS instance either through Management Studio or Excel.

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply