SRD oracle建立dblink到ORACLE ERP；并创建Select 权限的用户给到ORACLE ERP

一、SRD oracle建立db link

    1、使用sys用户创建

            a.oracle erp提供用户名，密码，IP地址，实例名：

            b.用户名：apps,密码apps,

            c.IP，实例名如下链接，复制即可

(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.18.1.87)(PORT = 1546)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = DEV) ))

二、给oracle eRP 创建用户，select

1.创建角色 

--CREATE ROLE SELECT_ROLE;

2.给角色分配权限 

grant SELECT ANY DICTIONARY to SELECT_ROLE; 

grant SELECT ANY TABLE to SELECT_ROLE; 

grant SELECT ANY TRANSACTION to SELECT_ROLE; 

grant SELECT ANY SEQUENCE to SELECT_ROLE;

2-1.创建用户：

create user oraerpdev_dblinkuser identified by ***;

grant connect,resource to oraerp_dblinkuser;

3.把角色赋予指定账户 

grant SELECT_ROLE to oraerpdev_dblinkuser;

4.删除角色 

--drop role SELECT_ROLE;

5.检查角色的权限 

--select * from dba_sys_privs where grantee='SELECT_ROLE'