Database Role Dialog Box
Use this dialog box to create or edit a database role.
This dialog box is displayed when you perform any of the following actions in Database Role Manager:
- Click New or Edit.
-or-
- In a row in the list, click in any column except Role, 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 Database Role dialog box has four tabs. For more information about the tabs, click a link in the following table:
| To do this | See |
|---|---|
| Maintain the list of users and groups in the role. | Membership Tab (Database Role Dialog Box) |
| Grant or deny access to the cubes in the database. | Cubes Tab (Database Role Dialog Box) |
| Grant or deny access to the data mining models in the database. | Mining Models Tab (Database Role Dialog Box) |
| Control the role's access to dimensions in the database. | Dimensions Tab (Database Role Dialog Box) |
Options
The following options are available for all tabs.
Role name
Enter the name of the role. You can enter a maximum of 50 characters; the name must begin with an alphabetical character. If you are editing an existing role, this box displays the name of that role, and you cannot change it.
Description
Enter the description of the role. You can enter a maximum of 200 characters.
Enforce on
Select 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.