I have a database running on DB2 v9.7.5. I created a new schema say SCHM and a new user called USR1.
I granted connected privilege and also select/insert/update provileges on the SCHM schema to the user USR1.
But strange I am NOT able to the connect to the database with the new user USR1 rather I am able to login throu the app with the old users which have the same privileges.
Here I am able to connect to the database from the db2cmd as : db2 "connect to dbs user usr1 using usr12345"
but not able to connect from the java app
Thanks for your time,
This topic has been locked.
Pinned topic Unable to connect from a new user created through application
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
nivanov1 100000H9H7231 Posts
Re: Unable to connect from a new user created through application2012-12-06T16:35:45ZThis is the accepted answer. This is the accepted answer.> but not able to connect from the java app
I think the error is on line 34 of your java code.