You are administering a SQL Server Analysts Services (SSAS) database on a server. The database hosts a financial cube based on a SQL Azure database.
You need to grant write access to the financial cube for all users in the group USAPowerUsers.
Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)
Select and Place:
Correct Answer:
Explanation/Reference:
Box 1: In the SQL Management Studio (SSMS), connect to the SSAS instance on the server.
Box 2: Create a new role for the database.
Box 3: Add the USAPowerUsers group to the role. Set the cube access for the role to Read and Process.
Note:
* A member of the server role for Microsoft SQL Server Analysis Services, or a member of a database role that has Full Control (Administrator) permissions in a particular database, can create a database role that only has permission to process specified objects within the database.
Giving a database role permission to process a database object lets an administrator delegate the task of processing certain objects, without also granting extraneous permissions to the user who is performing the processing.
* To give a database role permission to process a cube
* There is no write permissions on a cube.
Reference: Grant Process Permissions on an Analysis Services Multidimensional Database