I have created a table in my database ... i had also created a user and provided the access for "insert , update, delete'.

Now if the user try to insert data using a DB2 client ..it is throwing an error as

Query :

INSERT INTO ITMUSER.PM_MASTER_RAW_COPY VALUES('C_WP1xL_S01xPS_01xPC_01xaP_TEST','2010-09-03 05:00:00.077','WT','C_WP1xL_S01xPS_01xPC_01x','PAC ','1.1009E+15',0,'NULL','NULL','HVAC')

Error :

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 "GEMS_ADMIN" does not have the privilege to perform operation "EXECUTE" on object "NULLID.SQLC2E06". SQLSTATE=42501


As per this error ...i have checked the privilages, the required privilage is available.

if with the same user im trying to insert it from the Db2 Server itself , it is happening.. no error faced.

help me how to rectify this .

2. If the DB2 utility programs need to be rebound to the database, the
database administrator can accomplish this by issuing one of the
following CLP command from the bnd subdirectory of the instance,
while connected to the database:
* "DB2 bind @db2ubind.lst blocking all grant public" for the DB2
utilities.
* "DB2 bind @db2cli.lst blocking all grant public" for CLI.

run the above in client


To grant EXECUTE privilege on a package use the GRANT statement, for
example: GRANT EXECUTE ON PACKAGE NULLID.SYSH200 TO PUBLIC.

regds
paul

Hey Mathew..

Thanks a lot buddy its working....

hey this error came again with another package name..

i again execute the same command and granted the permisiion.

my question is -- why it is comin only for that user and not for other ??
why in every client it shows different package ??

help me!