在远程主机上安装了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的客户端就是需要设置权限才能访问数据库造成的,求大神解答
确定用的是V10.5的client端做的么?
不行就
db2 grant execute on package NULLID.SQLC2K26 to public再不行试试
grant dataaccess on database to xxx
用V10.5的客户端进行一下三大bind