oracle给用户赋dblink权限

create   database link 别名(可任意起)
 connect to 需要连接库的用户名identified by 需要连接库的用户名
  using '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS =(PROTOCOL = TCP)(HOST = 10.50.182.11)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = testdb)))';
原文地址:https://www.cnblogs.com/jwdd/p/10011786.html