Databases Reference
In-Depth Information
Figure 19-7
2. Click the Membership tab in the roles designer. Click the Add button
to add a user to this role, and add the user David. You already cre-
ated a user account for David earlier in this section. David's login ac-
count will be <machinename>\David, where machine name is the
name of the machine you are working on. When you click the Add
button you will see a dialog where you can enter the domain-
name\loginname. Enter your machine name followed by "\David" in
this dialog and then click OK. You will now see that the user David
has been added to the role Role as shown in
Figure 19-8
.
Figure 19-8
3. The next step is to provide access to the cubes and dimensions in
the database. Click the Cubes view. You will now see the list of
cubes within the database. You can see your UDM Dimension Secur-
ity. From the drop-down list box under Access, select Read access to
the UDM as shown in
Figure 19-9
. By selecting this access type you
have allowed users in this role the ability to read the data in the
cube. In addition to providing access to the cube, you can also
provide access to the users to drill-through to detail data or to pro-
cess the cube in this pane. Leave the Local Cube/ Drillthrough Ac-
cess option to None.
Search WWH ::
Custom Search