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:
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?
Feedback
thumb_up
Yes
thumb_down
No