select * from user_sys_privs t where t.privilege like upper('%link%');
select * from user_sys_privs t where t.privilege like '%LINK%';
USERNAME PRIVILEGE ADM
------------------------------ ---------------------------------------- ---
SYS DROP PUBLIC DATABASE LINK NO
SYS CREATE DATABASE LINK NO
SYS CREATE PUBLIC DATABASE LINK NO
可以看出在数据库中dblink有三种权限
CREATE DATABASE LINK
(所创建的dblink只能是创建者能使用,别的用户使用不了),
CREATE PUBLIC DATABASE LINK
(public表示所创建的dblink所有用户都可以使用),
DROP PUBLIC DATABASE LINK。
在sys用户下,把 CREATE PUBLIC DATABASE LINK,DROP PUBLIC DATABASE LINK权限授予给你的用户
grant CREATE PUBLIC DATABASE LINK,DROP PUBLIC DATABASE LINK to jrtsch;
create database link to_test
connect to jrtsch identified by jrt2010
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.102.105)(PORT = 1521)))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = jrtdbtest)))'
使用
select * from tsubchannel@to_test;
参考
[url]http://www.poluoluo.com/jzxy/201011/98780.html[/url]