写个脚本呗,怕麻烦可以这样:db2 -z grant.sql -x "select 'GRANT SELECT ON TABLE '||tabname||'TO USER USERNAME' from syscat.tables where tabschema='SCHEMA'"db2 -tvf grant.sql
显示全部写个脚本呗,怕麻烦可以这样:
db2 -z grant.sql -x "select 'GRANT SELECT ON TABLE '||tabname||'TO USER USERNAME' from syscat.tables where tabschema='SCHEMA'"
db2 -tvf grant.sql
收起