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.