DBLINK创建:80机器对应用户apps创建
create public database link LINK.AUSDBconnect to tolinkuser IDENTIFIED BY tolinkuser123
using '(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.185)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=crm)))'
DBLINK创建授权、删除、访问:
grant create public database link to auportal;#80机器对应用户dba创建
SELECT * FROM ausdb.BA_USER_INFO@LINK.AUSDB;#80机器apps访问
表访问授权:
grant select on ausdb.BA_USER_INFO to tolinkuser;