本文共 430 字，大约阅读时间需要 1 分钟。
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';
转载地址：http://qkkzl.baihongyu.com/