Previous Topic: SSO Using CloudMinder as an OAuth Authorization ServerNext Topic: Create an Identity Provider for CA Directory

Single Sign-On Service › SSO Getting Started Guide › SSO Using CloudMinder as an OAuth Authorization Server › Create the OTK/OIDC Database

Create the OTK/OIDC Database

Create the Layer 7 Oracle tablespaces, and an Oracle user, for your tenant.

Note: Perform this procedure for each tenant for which you configure CA CloudMinder as an external IdP using OAuth. Perform this procedure only once for each tenant, even if the tenant has many OAuth clients.

Follow these steps:

  1. Connect to the CloudMinder Oracle database as the system user.

    For example, connect with SQL Developer.

  2. Open the following file: 
    oracle_oidc.sql
  3. Save a copy of the file with a name that is specific to the tenant for which you are configuring OAuth.

    For example: 

    oracle_oidc_forwardinc.sql
  4. Replace all instances of <OTKDB-USERNAME> with a user name you choose. Choose a user name that is unique to the current tenant.
  5. Replace <OTKDB-PASSWORD> with a password you choose.

    Note: Make a note of the username and password for use later in the configuration process.

  6. Save and close the file.
  7. Execute the modified version of the script.
  8. Click Commit.