select
'grant select,update,insert,delete on '||trim(tabschema)||'.'||tabname||' to'||' user <User Name>;'
from syscat.tables where tabschema='<Schema Name>' and type='T';
select
'grant select,update,insert,delete on '||trim(tabschema)||'.'||tabname||' to'||' user <User Name>;'
from syscat.tables where tabschema='<Schema Name>' and type='T';