A user wants to access a test-database (v8.2 aix) by means of DbVisualizer (
DbVisualizer - The Universal Database Tool). So I grant him connect & select rights on the tables and views and also select rights on the SYSCAT views.
For the CLI this is sufficient, using his user-id I can make a connection and retrieve the data from the tables.
But dbvis won't work yet. I can make the connection, look at the structure of the tables but I cannot access data.
I get
Code:
DB2 SQL Error: SQLCODE=-551, SQLSTATE=42501, SQLERRMC=xxxx;EXECUTE;NULLID.SYSSH200, DRIVER=3.50.152
Strange. The re-bind of @db2ubind.lst and @db2cli.lst had no effect.
Anybody an idea?