Setting Up Data Security By Provisioning User Accounts Manually

During an OTBI-Enterprise implementation, Implementors provision users with access to specific areas of the data warehouse. You can either provision users manually one-by-one as described here, or import provisioning data in a bulk load (see Setting Up Data Security By Importing User Data).

Provisioning a user with access to areas in the OTBI-Enterprise data warehouse

To set up data security, you use Configuration Manager to assign functional areas to user roles.
  1. In Configuration Manager, select the Manage Data Security link on the Tasks pane.
    The User Data Security Objects dialog, which shows user to data object mappings.
    Description of GUID-E5BB605F-F3C3-48A8-BC09-029E7B135B6D-default.gif
  2. Click the Add icon (Add icon) to display the New Security Definition dialog.
    The New Security Definition dialog, which you use to provide users with access to areas in the data warehouse.
    Description of GUID-4C1A394A-91F1-43CA-BD7E-C979B05AFE82-default.gif
  3. For each user that you want to provision, do the following:
    1. In the Source Instance drop down list, select the data source that you are deploying.
    2. In the Secure by Object drop down list, select the data warehouse object that you want the user to access. For example, HR Department.
    3. In the Users area, move the user or users that you want to provision from the left hand list to the right hand list.
      To filter the Users list, enter the first characters of the user name that you want to provision into the User Filter field.
    4. In the Values area, move the data areas that you want users to access from the left hand list to the right hand list.
      To filter the Users list, enter the first characters of the value into the Value Filter field.
      The New Security Definition dialog, showing example settings.
      Description of GUID-D215A161-FA45-445F-85D4-A7E991AEE6DC-default.gif
    5. Click OK to save the details.
  4. Repeat the above step for every user that you want to provision.
    The User Data Security Objects dialog, which shows a list of user to data object mappings.
    Description of GUID-85622878-ED2D-42A1-96B2-F1EA4452FCA1-default.gif