I want to do something that seems like it should be very simple... I have single db2 instance, single db on it, I need a single user's credentials that will work to login via jdbc and have full rights to the DB (i.e. create/drop schema, etc) But I can't get it to work.
I have a db2 10.5 instance installed on a RHEL 7 VM - I have created a DB, lets call it db123
I can access the DB fine if I am logged into VM on command line. The username is dbinst1.
I just want to be able to connect to this via squirrel (or other jdbc based client). But I am getting authentication failure. As far as I understand db2 uses OS authentication. I am unable to log in as user db2inst1 it says
com.ibm.db2.jcc.am.SqlInvalidAuthorizationSpecException: [jcc][t4][3.68.61] Connection authorization failure occurred. Reason: User ID or Password invalid. ERRORCODE=-4214, SQLSTATE=28000
I thought maybe that user is now allowed to log in remote - so I create another user, lets say user123. I added them to the db2inst1 group (which I think means they should have admin rights), I also get same message when I try to login to that user via squirrel.