å¯ä»¥å æ¯å¦ä½ æ A B两个ç¨æ· Aä¸æ表aa ï¼Bä¸æ表bb
ä½ åªè¦å¨Aä¸ grant select on aa to B; ï¼è¿å¯ä»¥é
ç½®insertï¼updateï¼deleteæéï¼è¿æ ·å°±è½å¨Bä¸å建è§å¾è®¿é®å°Aä¸çaa表äºï¼ä½æ¯è¡¨åè¦A.aa,
è¦æ¯åªæ³åaaçè¯ï¼éè¦å¨Bä¸å建åä¹è¯ï¼create synonym B.aa for A.aa; è¿æ ·Bå°±å¯ä»¥å使ç¨èªå·±ç表ä¸æ ·ä½¿ç¨aa表äºã
温馨提示:答案为网友推荐,仅供参考