5 Configuring database credentials

This chapter includes the following topics:

• Storing database credentials

• Setting up permissions for the credential store

Storing database credentials

1. In an internet browser, enter the URL for the Oracle Enterprise Manager, such as the following:

   https://<server_name>:7002/em

2. Type the WebLogic administrator credentials, and click Login.

   The Oracle Enterprise Manager appears.

3. On the left, expand WebLogic Domain, and select empirica.

4. Expand the WebLogic Domain menu, located below the empirica page title, and select Security > Credentials.

   The Credentials page appears.

5. Create a map for credentials for the Empirica Healthcare Analysis application:

   1. In the Credentials table, click Create Map.

      The Create Map dialog box appears.

   2. Type the following map name:

      oracle.hsgbu.empirica

   3. Click OK.

6. Create a key for the credentials for the Empirica Healthcare Analysis database account:

   1. In the Credentials table, click Create Key.

   2. Fill in the following fields. Text fields are case-sensitive.

      • Select Map—Select the map you just created.

      • Key—Type the following value:

        DatabaseCredentials

      • Type—Select Password.

      • User Name, Password, Confirm Password—Type the login information for the Empirica Healthcare Analysis database schema. The default user name is healthcare.

      • Description—Type the following value:

        Empirica Healthcare Analysis schema username and password

   3. Click OK.

7. To see the keys you created, expand the map in the Credentials table.

Setting up permissions for the credential store

You must set up file access permissions for the Empirica Healthcare Analysis application to access the credential store. Otherwise, the Empirica Healthcare Analysis application cannot start, and users cannot login.

1. In the Oracle Enterprise Manager, on the left, expand WebLogic Domain, and select empirica.

2. Expand the WebLogic Domain menu, located below the empirica page title, and select Security > System Policies.

   The System Policies page appears.

3. In the System Policies table, click Create.

   The System Policies > Create System Grant page appears.

4. In the Codebase field, type the case-sensitive codebase, such as:

   file:${oracle.deployed.app.dir}/Healthcare${oracle.deployed.app.ext}

   
   

   Note: Use the codebase value as is unless you plan to use a context root value other than the default value of Healthcare. For more information, see Creating the Empirica Healthcare Analysis deployment in WebLogic.

   
   

5. Add a permission:

   1. Click Add.

      The Add Permission page appears.

   2. Select the Select here to enter details for a new permission check box, located at the bottom of the page.

   3. Type the following values for the fields below the check box:

      • Permission Class—oracle.security.jps.service.credstore.CredentialAccessPermission

      • Resource Name—context=SYSTEM,mapName=oracle.hsgbu.empirica,keyName=*

      • Permission Actions—read

   4. Click OK.

      The System Policies > Create System Grant page appears.

6. Click OK.

   The permission is saved. The System Policies page appears.

7. Search for the permission you just created:

   1. From the Name drop-down list, select Includes.

   2. In the field after the Name field, type Healthcare or the intended application context root. For more information, see Creating the Empirica Healthcare Analysis deployment in WebLogic.

   3. Click the Search button.

      The newly created permission appears in the table.

8. Create a permission based on the permission:

   1. Select the permission in the table, and click Create Like.

      The System Policies > Create System Grant page appears.

   2. Type a codebase value, such as the following value:

      file:${domain.home}/servers/${weblogic.Name}/stage/Healthcare/Healthcare${oracle.deployed.app.ext}

      
      

      Note: Use the codebase value as is unless you plan to use a context root value other than the default value of Healthcare. For more information, see Creating the Empirica Healthcare Analysis deployment in WebLogic.

      
      

   3. Click OK.

      The permission is added.

9. Search for the permission you just created:

   1. From the Name drop-down list, select Includes.

   2. In the field after the Name field, type Healthcare or the intended application context root. For more information, see Creating the Empirica Healthcare Analysis deployment in WebLogic.

   3. Click the Search button.

      The newly created permissions appear in the table.

10. Create a permission based on the permission:

    1. Select a permission in the table, and click Create Like.

       The System Policies > Create System Grant page appears.

    2. Type a codebase value, such as the following value:

       file:${wls.home}/../../patch_wls1036/patch_jars/-

       
       

       Note: This directory should reflect the directory where you installed the patch for WebLogic.

       
       

    3. Click OK.

       The permission is added.