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 default, 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 hierarchy. 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.
