How to configure users other than the owner of the backing store schema who has DBA rights?

How to configure users other than the owner of the backing store schema who has DBA rights?

book

Article ID: KB0092325

calendar_today

Updated On:

Products Versions
TIBCO BusinessEvents Enterprise Edition -
Not Applicable -

Description

Resolution:
Description:
===========
How to configure users other than the owner of the backing store schema who has DBA rights?

Environment:
===========
BusinessEvents 3.x,4.x,5.x
All Operating Systems

Resolution:
========
Follow the steps  below to allow username other than the owner of backing store schema.

1). Create a backing store database with be-user schema (with proper DBA access).

2). Create another user 'test-user' and grant the basic CURD (Create, Update, Read and Delete)  privileges on this schema to the test-user.

3). Add be-user to the schema property in the tra file as shown below. Note: Add the property to all the tra files.

   be.oracle.dburi.schema.0 be_user

4). Modify the JDBC connection palatte with the test-user and rebuild the ear.

5). Start the cache server and engines and check if the cache server and engines are using the test-user id to connect to the backing store database.

Issue/Introduction

How to configure users other than the owner of the backing store schema who has DBA rights?