oracle 创建同义词赋权创建dblink

oracle 的两个用户 yinzc0509   和yinzc0202

需求：我要在yinzc0202用户下访问yinzc0909的视图：VJK_NC_ACCOUNT_BANKINFO

1、首先创建yinzc0202的用户。

2、在yinzc0909用户下执行，赋权操作

      grant select on VJK_NC_ACCOUNT_BANKINFO to YINZC0202;

3、在yinzc0202下，建立同义词  ，名字叫haha

    create or replace synonym haha for YINZC0509.VJK_NC_ACCOUNT_BANKINFO

这样就可以在yinzc0202用户下访问haha视图 就是VJK_NC_ACCOUNT_BANKINFO

 

oracle创建dblink

删除dblink：drop database link yinzc;

create database link yinzc
 connect to “用户名” identified by “密码”
 using '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS =(PROTOCOL = TCP)(HOST = 10.50.111.2)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = orcl)))'

查询：select t.*FROM  table@yinzc t ；