O'Reilly logo

Getting Started with SQL Server 2012 Cube Development by Simon Lidberg

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required