udb ver 8.1 aix 5.2

we are trying to compile a SP using
db2 -td@ -f new_sp.sql

but its giving 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 "GEN01" does not have the privilege to perform operation "SELECT" on
object "LEN.CM_TRAN". LINE NUMBER=259. SQLSTATE=42501

but the same user can select any rows from LEN.CM_TRAN table. So why it gives such error.

What could be wrong?

Thanks,
j

When I granted 'select' right on this table to the user it could compile the SP.
But this user already had select right on this table through 'group' membership and could run select queries before.

Why do we have to grant 'select' to the user just to compile the SP?

we have udb ver 8.1 on aix 5.2