Databases Reference
In-Depth Information
Figure 19-9
4. After providing access to the cube, you can provide access to the
database dimensions as well as the cube dimensions in the Dimen-
sions View, as shown in
Figure 19-10
. The Select Dimension Set op-
tion allows you to choose the database dimensions or the cube di-
mensions. The default view shows all the dimensions in the data-
base. Similar to providing access to the cube, you can provide Read
or Read/Write access to each of the dimensions. If you specify Read
definition, users have the ability to send discover statements to see
the metadata information associated with the dimension. For the
database dimension objects you can specify administrative tasks of
read definition and processing, but for the cube dimension objects
you can only specify access to read or read/write. You have the op-
tion to inherit the permissions specified for database dimensions by
selecting the inherit check box next to the cube dimension. You can
override the permissions set for database dimensions for cube di-
mensions by deselecting the checkbox under inherit column and
then selecting appropriate permissions from the Access column. This
is helpful whenever you have a dimension that is shared across mul-
tiple cubes within the database and users of a specific role only have
specific permissions to dimensions within a specific cube. Provide
Read access to all three dimensions as shown in
Figure 19-10
.
Figure 19-10
5. Click the Dimension Data tab to restrict the members that can be
seen by the current role. Specifically, you are restricting access to
Search WWH ::
Custom Search