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?