Security Overview (Analysis Services - Multidimensional Data)
The process of securing Microsoft SQL Server Analysis Services occurs at two different levels: instance and user. The instance level is composed of all the physical elements used by an Analysis Services instance that must be secured to make sure that only authorized users have the permission to access them. These elements include data folders, applications, etc. The user level is composed of the permissions granted to the users that allow them to access the information stored in the Analysis Services database and, also, prevents users from accessing data beyond their privileges.
Securing an Analysis Services Instance
Securing the Analysis Services instance level includes:
The computer where the Analysis Services instance is running
The Windows operating system where the Analysis Services instance is running
The applications that access the Analysis Services instance
The folders that contain data files used by the Analysis Services instance
The operating system account used the Analysis Services instance
The client access to the Analysis Services instance
The Analysis Services instance configuration properties
For More Information:Securing the Analysis Services Instance
User Access Security Architecture
Securing the Analysis Services user level includes:
Establishing a mechanism to authenticate users
Defining the users allow permission to the Server Role
Defining OLAP objects level security
Defining Data Mining objects level security
Defining Assemblies and Stored Procedures level security
Enabling or disabling instance configuration properties
For More Information:User Access Security Architecture