Has anyone hit a situation where a user id is created and available on AIX (5.3) in a specified group. The group has been assigned correct permissions for select,insert,update,delete on tables in midrange db2 version 9.5 fp4 plus schema permissions but inidividual rights have not been granted.
When the user attempts to create the sql stored proc they hit a -551 on the table access of each table accessed. A direct sql execution against the same table with the same id works just fine but from within the create stored proc it fails each time. It appears that the create stored proc is not utilizing the user group!

Please help!

Perhaps this technote will help:
https://www-304.ibm.com/support/docv...id=swg21224422

that sure does answer it but boy do I hate that answer!!!!

wanted to get away from individual id management within the database.

thanks a bunch for the answer though