Export (0) Print
Expand All

End-User Security

SQL Server 2000

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

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
© 2015 Microsoft