End user security can be enforced at multiple levels. The levels are as under:

1. Server level : This controls whether an end user can connect to the Analysis server with a client application.

2. Database level: Defines the databases that the end user can view on the Analysis server

3. Cube/Mining model level: Defines the cubes or mining models a connected end user can view.

4. Dimension Level: This defines the dimension members that can be viewed by an end user connected to the Analysis server.

5. Cell Level: Defines the cube cells that a connected end user can access. It also sets the read/write permissions for write enabled cubes and limits the cells that an end user can update.

Creating Users and Groups in the Operating system (Windows 2000)

Security in Analysis server is determined by the operating system User and Group accounts. The first step in giving the user access to database and database objects is the creation of the user account in the operating system. User accounts have to be created in the same domain in which the Analysis server is installed or in a trusted domain in which the Analysis server is a member.

In Windows 2000 Click Settings > Control Panel > Administrative tools > Computer management >Local users and groups. Within the user manager new users and groups can be created.

Right click the user folder and select New user…

Type in the name of the user. In this case WSSmith. Type in the full name as William Samuel Smith. Let us leave the password text box empty and insist that the user must change his password by checking the check box. Then click Create button. Note that a new user is added to the users.