I have a requirement to grant read access on SSAS cubes to one windows group and read/write access to another group. I have multiple SSAS cubes on my server.
The question is:
- What minimum rights should I grant to the user?
- Is there a way to apply this rights on multiple cubes. As manually creating roles on each SSAS cubes is painful. I have lot of SSAS cubes. So looking for an easy way to do this.