When creating the tables for Backend Datastore feature, by default, the initialize_database.sql, grants DBA access to the be_user, is it mandatory to grant DBA access to this be_user?
Article ID: KB0091517
Updated On:
| Products | Versions |
|---|---|
| TIBCO BusinessEvents Enterprise Edition | - |
| Not Applicable | - |
Description
Resolution:
The initialize_database.sql, shipped with TIBCO Business Events, creates the be_user and grants DBA access to it as this user has to create the views and tables generated by the be-oradeploy utility. Once these tables and views are created the inference engines just do the basic CRUD (Create/Insert, Read, Update and Delete) operations.
If your Database Administrator does not allow this be_user to have DBA rights at all the time, we suggest you to create the tables and views by logging in as a user with priviledges to create the tables and views, run the SQL acripts generated by the be_oradeploy tool and then grant the be_user to do the basic CRUD operations on these tables and views.
The initialize_database.sql, shipped with TIBCO Business Events, creates the be_user and grants DBA access to it as this user has to create the views and tables generated by the be-oradeploy utility. Once these tables and views are created the inference engines just do the basic CRUD (Create/Insert, Read, Update and Delete) operations.
If your Database Administrator does not allow this be_user to have DBA rights at all the time, we suggest you to create the tables and views by logging in as a user with priviledges to create the tables and views, run the SQL acripts generated by the be_oradeploy tool and then grant the be_user to do the basic CRUD operations on these tables and views.
Issue/Introduction
When creating the tables for Backend Datastore feature, by default, the initialize_database.sql, grants DBA access to the be_user, is it mandatory to grant DBA access to this be_user?
Feedback
Yes
No
Powered by
