Oracle不同数据库之间的授权

2014-11-24 18:02:16 · 作者: · 浏览: 0

GRANT SELECT ON A.table TO B;


GRANT INSERT ON A.table TO B;


GRANT UPDATE ON A.table TO B;


GRANT DELETE ON A.table TO B;


对多张表操作:


select 'grant select on '||table_name||' to usr2' from user_tables;