db2 -x "select 'grant select on table '||trim(tabschema)||'.'||trim(tabname)||' to user DB2READ;' from syscat.tables where type='T' " > grant_select.sqldb2 -tvf grant_select.sql
显示全部db2 -x "select 'grant select on table '||trim(tabschema)||'.'||trim(tabname)||' to user DB2READ;' from syscat.tables where type='T' " > grant_select.sql
db2 -tvf grant_select.sql
收起