"Doug Ly" <de******@dev.null> wrote in message
news:GT******************@newssvr23.news.prodigy.c om...
Hi ,
connect to Blah user blah using blah
------------------------------------------------------------------------
Database Connection Information
Database server = DB2/6000 7.2.3
SQL authorization ID = Blah
Local database alias = Blah
I recieved this error message when using the DB2 command center.
--------------------------- Command entered ----------------------------
select *
from Db2inst1.test
------------------------------------------------------------------------
SQL0551N "Blah" does not have the privilege to perform operation
"EXECUTE" on
object "NULLID.SQLC2D01". SQLSTATE=42501
It's weird because I can do anything with that account on Lotus Approach
or WinSQL.
Thank you for your help.
Lotus is probably using the ODBC interface, and the Command Center is using
the CLI. Try rebinding the packages using the Client Configuration Assistant
or grant execute on the package to public (or whatever). The rebind should
have been performed with each fixpak upgrade, but it may have been missed.