Export (0) Print
Expand All

Secure Operation (Analysis Services - Multidimensional Data)

Securing Analysis Services includes maintaining a secure environment and following all best practices for system security. This page provides links to help you locate the information that you need in order to more securely operate and manage your Analysis Services environment.

Securing the Analysis Services Instance

Provides a general overview of the steps required to protect an instance, and to make sure that only authorized users have permission to access it.

User Access Security Architecture

Provides a general overview of the steps required to protect the Analysis Services objects (such as databases, dimensions, cubes, data mining models, etc.), and to make sure that only authorized users have permission to access them.

Securing Client Communication with an Analysis Services Instance

The communication stream between clients and an instance of Microsoft SQL Server Analysis Services must be secured. During the setup process, default security settings are configured that control this communications stream. The default security settings try to guarantee that communication between clients and an instance of Analysis Services is as secure as possible. However, depending on the sensitivity of the data and the security of the networks across which the data is accessed, these default security settings might not be suitable for you. This topic describes how to configure the communications to suit your needs.

Granting Administrative Access

In Microsoft SQL Server, members of the server role for SQL Server Analysis Services can create one or more database roles within a database. They can then grant full or limited administrative permissions within the database to these database roles. Finally, they can then add Microsoft Windows users and groups to these database roles.

Granting User Access

User access to objects such as cubes, dimensions, and mining models within an instance of Microsoft SQL Server Analysis Services is granted through membership in one or more database roles. Analysis Services administrators create these database roles, grant read or read/write permissions on Analysis Services objects for these roles, and then add Microsoft Windows users and groups to the roles.

Community Additions

ADD
Show:
© 2014 Microsoft