Previous Topic: Configure HazelcastNext Topic: Install JDBC Drivers and Data Sources on the Workpoint Cluster


Create Database Users

This procedure describes how to create database users to synchronize Java Messaging Service (JMS) topics.

Follow these steps:

  1. Create the following database users:
  2. (Oracle only) Verify that the databases have the appropriate permissions by running the following SQL commands as user sys:
    grant select on pending_trans$ to WPDS;
    grant select on dba_2pc_pending to WPDS;
    grant select on dba_pending_transactions to WPDS;
    
  3. (Oracle only) Restart the Oracle server.

    You have created database users to synchronize Java Messaging Service (JMS) topics.

Next, you install Server JDBC drivers and data sources on the Workpoint cluster.