Analysis Services
End-User Security
End-user security is concerned with users' access to data on the Analysis server through client applications such as Microsoft® Excel. It affects the ability of users to connect to the Analysis server, which data they can access, and whether they have read or read/write access.
End-user security relies on the definition of user accounts and groups in Microsoft Windows NT® 4.0 or Windows® 2000 and on the creation of Microsoft SQL Server™ Analysis Services security roles, each specifying a set of users and groups. The process of implementing end-user security is summarized in the following table.
| Phase | Description | For more information |
|---|---|---|
| 1 | Review and revise Windows NT 4.0 or Windows 2000 user accounts and groups in accordance with the various access requirements of your end users. | User Accounts and Groups |
| 2 | Create security roles and assign each role to the cubes or data mining models that the users in the role are permitted to access. | Database, Cube, and Mining Model Roles and Creating Security Roles |
| 3 | Define each role assigned to a cube or mining model. Each role's definition can vary for each cube or mining model to which it is assigned. | Levels of End-User Security and Creating Security Roles |