DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=DB2ADMIN.LOGIN

SQL CODE 551 occurred because the connecting user does not have privileges to perform operations.

Go to Control Center - Go to User Group and Object and select DB2ADMIN(assume this user is the one use to connect to DB2)

enter image description here

Check all the check box as the following

enter image description here

Grant Schema access to the user enter image description here

Grant Tables access to the user enter image description here

posted on 2013-06-11 17:26 duanxz 阅读(15960) 评论(0) 收藏举报