假设,使用server登陆数据库 然后server有查询client用户下面表pubcodeinfo的权限 select cust.id,cust.gender,pub.name from server.customerinfo cust left outer join client.pubcodeinfo pub on pub.guid=cust.gender
a admin with optiongrant select on table to userbselect * from table1,userb.table1 wher ....
select cust.id,cust.gender,pub.name from server.customerinfo cust
left outer join client.pubcodeinfo pub
on pub.guid=cust.gender