If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > What did I forget

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 08-10-10, 03:42
dr_te_z dr_te_z is offline
Registered User
 
Join Date: Jan 2009
Location: Zoetermeer, Holland
Posts: 555
What did I forget

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?
Reply With Quote
  #2 (permalink)  
Old 08-10-10, 04:06
Marcus_A Marcus_A is offline
Registered User
 
Join Date: May 2003
Location: USA
Posts: 5,198
Your bind parameters may be wrong. Get the fixpack install instructions for that exact fixpack release and execute the bind command exactly.

You might also need to do a remote bind to the database from the DB2 client running on the Windows machine where DB Visualizer is located (should be able to do this with Client Configuration Assistant GUI).
__________________
M. A. Feldman
IBM Certified DBA on DB2 for Linux, UNIX, and Windows
IBM Certified DBA on DB2 for z/OS and OS/390
Reply With Quote
  #3 (permalink)  
Old 08-16-10, 06:32
dr_te_z dr_te_z is offline
Registered User
 
Join Date: Jan 2009
Location: Zoetermeer, Holland
Posts: 555
No, that is not it. When I login with my own user-id (=DBADM) I can work as expected but when I login with the other userid I it does not work. It seems that somewhere in the JDBC-internals it tries to access more db2-objects. Anyone knows the minimum "GRANTS" to ensure seamless JDBC access?
Reply With Quote
  #4 (permalink)  
Old 08-16-10, 07:52
umayer umayer is offline
Registered User
 
Join Date: Dec 2005
Posts: 273
Did you GRANT EXECUTE ON PACKAGE NULLID.* TO that user ?
Reply With Quote
  #5 (permalink)  
Old 08-16-10, 08:34
Marcus_A Marcus_A is offline
Registered User
 
Join Date: May 2003
Location: USA
Posts: 5,198
Quote:
Originally Posted by dr_te_z View Post
No, that is not it. When I login with my own user-id (=DBADM) I can work as expected but when I login with the other userid I it does not work. It seems that somewhere in the JDBC-internals it tries to access more db2-objects. Anyone knows the minimum "GRANTS" to ensure seamless JDBC access?
That is a clear indication that the bind options are wrong (unless you actually tried to do the bind and it still does not work). Rebind does not work, you must use the exact syntax as contained in the fixpack instructions..
__________________
M. A. Feldman
IBM Certified DBA on DB2 for Linux, UNIX, and Windows
IBM Certified DBA on DB2 for z/OS and OS/390
Reply With Quote
  #6 (permalink)  
Old 08-17-10, 06:51
dr_te_z dr_te_z is offline
Registered User
 
Join Date: Jan 2009
Location: Zoetermeer, Holland
Posts: 555
Quote:
Originally Posted by umayer View Post
Did you GRANT EXECUTE ON PACKAGE NULLID.* TO that user ?
THANKS. That did the job!
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On