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, Windows® 2000, or Windows XP 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, Windows 2000, or Windows XP 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|