I created MQT table in IBM Z/0S DB2 V8. I was able to refresh that. But I want to know what type of access needed for user to do the same ( who has only select, insert,upadte,delete on this table. Do they need DB ADM on that database?

Thank you

Ravi

Try the SQL Reference Manual. It will list the authority needed for the REFRESH statement.

Not sure why you allow users to insert, update, or delete row in an MQT table. Maybe there is a good reason, but sounds a little dangerous to me.