Our partner has created a new database to us so we can use it as a test database. He gave us all addresses and connection information so we can use it to connect to the database.
I've asked here how to add a catalog to the database so we could connect to it and it work as it should.
After connecting to it we could not run any command always getting same error: We try to run:
create table test (id integer)
SQL0551N "MY_USER" does not have the required authorization or privilege to perform operation "EXECUTE" on object "NULLID.SQLC2H23". SQLSTATE=42501
And then we called to our partner telling him that and he send a screenshot executing same command and it work as it should.
I think that it worth to mention that he is at the terminal on the server and we are from our machine on the db2 client console.
So, is there any permission or authorization or grant that he should add to our
MY_USER user so we can run anything on it?
The strange thing is that when we connect with the same user on the TOAD client all commands works as it should. So my wild guess is something to do with the catalog we created.