Building Java SP for debug

[Steve Smith]

I am trying to build a Java SP for debug. The SP in question builds OK
normally. When building for debug I get the following 'permission' error:_

[IBM][CLI Driver][DB2/6000] SQL0551N "G2REPORT" does not have the privilege
to perform operation "SELECT" on object "SYSCAT.PROCEDURES". LINE NUMBER=1.
SQLSTATE=42501

I know the 'g2report' user does have select permission on syscat.procedures
table because I can run 'select * from syscat.procedures' via winsql and
this works fine.

Any ideas ?

Steve

[Steve Smith]

Dear All,

Have resolved this question. For some reason it would seem that win.sql will
let you 'select' from syscat.procedures even if the user you have logged on
as doesn't have select permission on that view. Strange.

Steve
"Steve Smith" <st*********@uk.fid-intl.com> wrote in message
news:_R**************@news-srv1.fmr.com...

I am trying to build a Java SP for debug. The SP in question builds OK
normally. When building for debug I get the following 'permission' error:_

[IBM][CLI Driver][DB2/6000] SQL0551N "G2REPORT" does not have the privilege to perform operation "SELECT" on object "SYSCAT.PROCEDURES". LINE NUMBER=1. SQLSTATE=42501

I know the 'g2report' user does have select permission on syscat.procedures table because I can run 'select * from syscat.procedures' via winsql and
this works fine.

Any ideas ?

Steve