Hi All,

I have created one procedure in Netezza called "P_REP_GET_BLOCK_COUNTS". Now if i am trying to GRANT the permission to PUBLIC, it is npt allowing me to do that.

----------------------------------------------------------------------------------------

GRANT EXECUTE ON P_REP_GET_BLOCK_COUNTS(VARCHAR(4000),VARCHAR(4000),INTEGER)  TO PUBLIC

Error: ERROR: GrantRevokeCommand: permission denied. (State:HY000, Native Code: 2D)

------------------------------------------------------------------------------------------

I am not able to understand the problem..

Can someone help me put here..??

Thanks in Advance,

Ravi