select 'grant all on ' || owner || '.' || table_name || ' to test;'
from dba_tables
where table_name in
('T_OPT_WAYBILL_STOCK', 'T_OPT_STOCK', 'T_OPT_PICK_HANDOVER_DETAIL');
select 'grant all on ' || owner || '.' || table_name || ' to test;'
from dba_tables
where table_name in
('T_OPT_WAYBILL_STOCK', 'T_OPT_STOCK', 'T_OPT_PICK_HANDOVER_DETAIL')
and owner = 'TFR';
本文转自aaa超超aaa 51CTO博客，原文链接:http://blog.51cto.com/10983441/1791285
