Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Cube Role Dialog Box
Collapse the table of content
Expand the table of content

Cube Role Dialog Box

SQL Server 2000

Cube Role Dialog Box

Use this dialog box to create or edit a cube role.

This dialog box is displayed when you perform any of the following actions in Cube Role Manager:

  • Click New or Edit.

  • In a checked row in the list, click in any column except Role or Description, and then click the edit (...) button. Depending on the column in which you click the edit (...) button, the appropriate tab is displayed, and the cursor is placed in the appropriate box.

The Cube Role dialog box has three tabs. For more information about the tabs, click a link in the following table.

To do this See
View a summary of the role definition. This tab is visible only when you are editing an existing role. Summary Tab (Cube Role Dialog Box)
Maintain the list of users and groups in the role.

Changes in this tab propagate to the database role and cube roles with the same name as the edited cube role.

Membership Tab (Cube Role Dialog Box)
Control the role's access to the dimensions in the cube for which the role is defined. Dimensions Tab (Cube Role Dialog Box)
Control the role's access to the cells in the cube for which the role is defined. Cells Tab (Cube Role Dialog Box)
Enable or disable cube linking, drillthrough, and SQL queries for the role. Options Tab (Cube Role Dialog Box)

Note  The default values for a cube role are derived from the database role of the same name.


The following options are displayed for all tabs.

Role name

View the name of the role. The name can be a maximum of 50 characters; it must begin with an alphabetical character. If you are editing an existing role, you cannot change the name of that role.


View the description of the role. You can enter a maximum of 200 characters. This is not available if you are editing an existing role.

Enforce on

View or set the location of security enforcement: Server or Client. Server enforcement is more secure but may slow performance. Client enforcement generally provides better performance but increases the risk of unauthorized access to data on the client workstation.

If Client is selected, queries might be resolved partially or completely at the client workstation.

If Server is selected, queries are resolved entirely on the Analysis server or at the data source. User-defined functions stored exclusively on client workstations cannot be used.

Restore Defaults

Click to replace the entire cube role definition with the definition of the database role of the same name as the cube role.

© 2015 Microsoft