Roles in SSAS Data mining

Question

Hello,

I have built an association mining model using SSAs and am having trouble with assigning a role. Whe I have a role that has full control , I am able to use the members
of that role to execute DMX queries whereas if I run a DMX query using a user who only has membership with Read defintion my query says the user does not have permission.

Why does this happen ? 

Answer 1

Can someone please help answer this ?

Thanks!

Answer 2

Hi Kirthika,

I'm not an expert on the subject of security and etc, but this or this could help, especially the last paragraph of the first link. Does your query uses OPENROWSET/OPENQUERY clauses? One can be solved by configuring (allowing) ad hoc openrowset queries, second can be probably solved only by adding write permissions.

Maybe someone will explain better..

Regards

Vladimir