db2客户端10.5与服务端9.7的问题
在远程主机上安装了db2 10.5的客户端，安装完成后db2 connect to datebase user xxx using xxx 可以连接数据库，但是执行insert，或者select语句就告诉我
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0551N The statement failed because the authorization ID does not have the
required authorization or privilege to perform the operation. Authorization
ID: "xxx". Operation: "EXECUTE". Object: "NULLID.SQLC2K26".
SQLSTATE=42501
但是我安装9.5客户端就可以insert或者select，查询了一下权限都是SYSADM的权限，所以不知道是因为客户端高于服务端导致的问题还是10.5的客户端就是需要设置权限才能访问数据库造成的，求大神解答
4同行回答
在数据库服务器上：
以实例用户连接数据库，然后执行
db2 GRANT execute ON PACKAGE "NULLID "."SQLC2K26" TO USER xxx
确定用的是V10.5的client端做的么？
不行就
db2 grant execute on package NULLID.SQLC2K26 to public再不行试试
grant dataaccess on database to xxx
怎么bind啊，大神能不能给个具体的方法
收起- 大神，给讲解一下呗
- db2 terminate db2 CONNECT TO dbname user USERID using PASSWORD db2 BIND pathdb2schema.bnd BLOCKING ALL GRANT PUBLIC SQLERROR CONTINUE db2 BIND path@db2ubind.lst BLOCKING ALL GRANT PUBLIC ACTION ADD db2 BIND path@db2cli.lst BLOCKING ALL GRANT PUBLIC ACTION ADD db2 terminate
- 大神，按着你这个执行了还是报一样的错误