Providing user access to the sample applications

DB2 OLAP Server provides a comprehensive security system for a secure multiple user environment. By default, the sample applications are created with a security access level of None, which means that no user can connect to the sample databases unless the user is defined as a supervisor.

The system supervisor, defined when the server component was installed, automatically has supervisor privilege. Therefore, the system supervisor can make the sample applications available to other users.

To provide all users with Write access to the sample databases, repeat the following procedure for each database.

  1. Log on using the system supervisor account.
  2. Open the Administration Services Console.
  3. From Enterprise View, find the appropriate server and application.
  4. Select the application, right click it, and select Edit properties.
  5. In the Application Properties window, select the General tab.
  6. For the Minimum access level option, select the Write option.

    For example, if you want all users to have at least Write access to all databases in the application (meaning that all users can update data values), select Write.

  7. From the Minimum Database Access group, select the Write option.
  8. Click Apply.

The applications are now ready for use. If you want to provide access to another application, repeat the procedure. If you want to use the Partitioning applications, follow the instructions in Setting the environment for the partitioning sample applications. If you do not want to use the Partitioning applications, your next step might be to create the appropriate user names to be able to log on to DB2 OLAP Server. See the Analytic Services Database Administrator's Guide for information on creating users.