Article From:https://www.cnblogs.com/xiaochina/p/9967007.html

  The emergence of problems is the continuous advancement of technology. In order to better realize the promotion of value!

01、View with

create view tab1 select * from B.tab1;       //Execute under User A

02、Synonym

grant CREATE SYNONYM  to A;   //DBAOr authorized users
create synonym tab1 for B.tab1;

03、Inter-account authorization

grant select on B  to A;    //AUsers can view tables under User B without prefixes, just like queries under User B.

Note: Authorization of table access to A user by B user is required.

Leave a Reply

Your email address will not be published. Required fields are marked *