Post reply

Cube processing access

  • August 24, 2010 at 10:30 pm

    #142516

    Hi All,

    We have analysis process cube but one of my team member not able to process the cube"She is getting an error don't have privilages to process the cube.

    She is having db_owner access on all the Databases which are used by Cube.

    I am not much understanding with Analysis service please help me .

    Thanks,

    Gangadhar

  • August 24, 2010 at 11:56 pm

    #1211461

    To give a database role permission to process a cube

    1. In SQL Server Management Studio, connect to the instance of Analysis Services, expand Roles for the appropriate database in Object Explorer, and then double-click a database role (or right-click Roles and select New Role to create a new database role). If this is a new role, make sure that you enter a name for the role in the Role name box.

    2. Click Cubes in the Select a Page pane, locate the cube in the Cube list, and then select the Process check box for the cube.

    3. Click the OK button.

    Granting Process Permissions

    http://www.dwexplorer.com
    @dtwegener

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

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