1、db2 connect to db ;2、db2 grant connect on database to user pub_query;3、用语句拼出来赋权语句:select 'GRANT SELECT ON TABLE '||TABSCHEMA||'.'||TABNAME||' TO USER pub_query;' from syscat.tables;4、复制出来结果,一把执行就好了...显示全部
1、db2 connect to db ; 2、db2 grant connect on database to user pub_query; 3、用语句拼出来赋权语句: select 'GRANT SELECT ON TABLE '||TABSCHEMA||'.'||TABNAME||' TO USER pub_query;' from syscat.tables; 4、复制出来结果,一把执行就好了