Grant Select privilege on all tables in schema to user in DB2

​Query:

1) Generate grant statement to grant select privilege to user on all tables in schema

select concat(concat('grant select,update on xmeta.',tabname),' to user iersuser;') T from syscat.tables where owner='XMETA'

The above query generate grant statements

2) Run the Grant Statement to grant select and update access for all tables to user in schema

grant select,update on xmeta.REPORTING_PARAMETERVALUE to user iersuser

​