可以给user1授权访问user2的表,如user2里面有个表t1;
用user2登陆:
grant select on t1 to user1;
用user1登陆就可以访问t1了:select * from user2.t1;
用user2登陆:
grant select on t1 to user1;
用user1登陆就可以访问t1了:select * from user2.t1;
from all_tables where upper(owner) = 'userb';spool end 修改一下ttt.sql文件
start d:\ttt.sql