hi all,

I am not aware of DB2 much, I read up some material but could not find if the schema permissions are inheritable to the objects created in the schema.

my intention is to achieve following, grant a permission to a schema such that all the objects created inside that (by any user) will be by default select, execute etc. privileges for a particular user.

can anyone tell me if it is possible?

grant are given on objects and not on schema
if you want give select authority on all tables, to a user, you have to grant select on each object to this user
this can be done with a script that reads the objects for a schema