Analysis Services Security Roles

Role allows us to access analysis services databases and cubes.

Two types of roles

Server Role

Members of the server role having administrator rights.

Database Roles

Database Roles created by members of server role. Members of database roles may have administrator permissions or read/write permissions to cubes,dimensions,cells etc.

Members having administrator  permissions can only process the databases,cubes or dimensions

Administrator Security
Cube Security
Dimension Security
Cell Security
Special Options

Tabular dynamic security

http://bipassion.wordpress.com/2012/10/01/ssas-tabular-dynamic-security/