Database Reference
In-Depth Information
Securing objects in Analysis Services
In addition to setting security to the database, you have the ability to secure individual
objects in the database. The following objects allow permissions to be set on them:
Object
Explanation
Data
source
Allows or disallows users to read the data source definition or to access
the underlying source in case ROLAP is used.
Cube
Allows or disallows the read access to cubes within a database. By de-
fault, rights are inherited by lower-level objects.
Cell
Gives or denies the rights to access specific cells within a cube to the
user.
Dimension Specifies if a specific dimension should be available.
Attribute Specifies the security on individual attributes in a dimension.
Note that lower-level objects will inherit security from objects above them in the hier-
archy. This means that if you give a user read access to a cube, by default, they will
have access to all measures and dimensions in that cube.
Search WWH ::
Custom Search