Sdílet prostřednictvím


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