How to change the Dynamic Workload Console user that updates
the settings repository on DB2.
Before you begin
To perform this task you need to have the TWSWEBUIAdministrator
role.
You must have switched the Dynamic Workload Console settings repository
from a local file to a database repository, as described in Changing settings repository.
About this task
Only users with database administrator rights are authorized
to initialize the Dynamic Workload Console related
tables on the database.
If you want the Dynamic Workload Console to access the database
repository with a user without database administrator privileges you
must follow these steps:
Procedure
- Create a new DB2 user and grant this user with SELECT,
INSERT, UPDATE, DELETE rights on all the following tables, belonging
to TDWC schema:
TDWC_EngineConnection
TDWC_QueryTask
TDWC_ReportTask
TDWC_MEQueryTask
TDWC_Credential
TDWC_ConfigurationProperty
TDWC_Preferenceable
The above are the default permissions.
However, if you need to restrict your policy, you can give the following
permissions to the new DB2user: revoke connect,bindadd, createtab, implicit_schema on database from public;
revoke use of tablespace USERSPACE1 from public;
grant use of tablespace userspace1 to user twsdb2;
grant createtab on database to user twsdb2;
grant implicit_schema on database to user twsdb2;
- Change Dynamic Workload Console user
accessing DB2
- From the navigation toolbar, click System Configuration > Manage Settings.
- In the Database Settings section,
specify the credentials of the newly created user that must to connect
to the database.
Note: As a result of this user switch, theDynamic Workload Console without database administrator
privileges will no longer be authorized to the following actions in
the Manage Settings panel: - Initialize database
- Import settings with Cancel and re-create option.