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
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')
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.
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
* "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.