SQL0551N "PARAPS01" does not have the privilege to perform operation
"EXECUTE" on object "NULLID.SQLC2D03". SQLSTATE=42501


i am getting this error.....

can we give execute on that object.
or do i have to bind it again...

Try this :

GRANT EXECUTE ON PACKAGE NULLID.SQLC2D03 TO USER PARAPS01

Is you have not enough authority contact your DB2 admin, i would do that for you.

My Question was Wrong.

Thats not waht i want.

How come we manually give rights on the NULLID packages?
They are internal to UDB. UDB shouldn't throw thses kind of errors?

But how come i got this error? Is some thing got screwd internally?

>>Is you have not enough authority contact your DB2 admin, i would do that for you.<<


yeah go ahead and do that...i appreciate )

The packages might have come with DB2, but IBM believe (and so do I) that they should be subject to the same security checks as anything else. However, IBM normally a) names their packages SYSxxxxx or DB2xxxxx and b) grants execute on them to PUBLIC as part of the installation.

Are you sure it came from IBM?

James Campbell

I am also getting similar kind of erro.

SQL0551N "tuskman" does not have the privilege to perform operation "EXECUTE"
on object "NULLID.SQLxxxE06". SQLSTATE=42501

I though the packaage SQL* are generated by UDB and UDB will grant EXECUTE permissions to public by default . Isn't it correct.

WHat is the solution to the above issue ?

OS :Aix , UDB 8.1 FP5.

Please indicate your DB2 version, fixpack, and OS, and describe exactly what you doing when this error occured.

When you bind the package list containing nullid packages, you will have to grant execute to public
Eg:

bind @db2ubind.lst blocking all grant public

Sathyaram

Marcus,


OS : AIX , UDB V8.1 FP7.
Our People soft admin guys is tyring to select count(*) from the table .
He couldn't able to do it. Not only him , the other application ids alos
not able to do the same things.

We have recently restoed a backup into this server. That is the only difference i can see. And recently upgrared to FP7 by our colleague.

tanks