JDBC Pools > Connection Properties , one user to connect different database component

, ,
1

Hi,

I have created TN ,IS and MWS database components using DBConfigurator.But DBAs have provided me only one user to connect to all 3 Schemas.

Please tell me while setting up JDBC pools ,what all properties I need to setup to limit the schema usage.

I have already tried this one :
jdbc:wm:oracle://elgwmdev:1527;serviceName=webm82d;TableFilter=‘’.‘WMB2B_IS’
User : WEBM
Pwd: *******
WEBM is the user DBAs has provided with all permissions provided.
but it’s not able to view tables under WMB2B_IS schema.

2

"WEBM is the user DBAs has provided with all permissions provided.
but it’s not able to view tables under WMB2B_IS schema."

Then they haven’t provided all the necessary permissions. WEBM should have full control over all the wM-related schemas.

3

Hi Reamon,

Just to clarify , WMB2B_IS was created using DB configurator and then WEBM user was created to access this schema.

Full control you mean is for DML and DDL too ?
WEBM has access to these schema with Insert,update,delete,select permissions.And logically i don’t think it needs anything else once all objects are there ? Correct me ?

4

Raised a case with Software AG and here is the solution :

jdbc:wm​:oracle://:;serviceName=;InitializationString=(ALTER SESSION SET CURRENT_SCHEMA=)

Thanks everybody for the help .

5

Thanks for the update. It looks like my post about the root issue was incorrect.