创建Database Link时的权限问题

显示全部楼层 · 2008-11-27 14:56:58

SQL> create database link dl1 connect to scott identified by tiger using 'net1';

create database link dl1 connect to scott identified by tiger using 'net1'

ORA-01031: 权限不足

SQL> select * from user_sys_privs;

USERNAME
PRIVILEGE
ADMIN_OPTION
------------------------- ---------------------------------------- ------------
SCOTT
CREATE DATABASE LINK
NO
SCOTT
UNLIMITED TABLESPACE
NO

SQL> create database link dl1 connect to scott identified by tiger using 'net1';

create database link dl1 connect to scott identified by tiger using 'net1'

ORA-01031: 权限不足

SQL> connect sys/xxx@net2 as sysdba
Connected to Oracle Database 11g Enterprise Edition Release 11.1.0.6.0
Connected as SYS

SQL> create database link dl1 connect to scott identified by tiger using 'net1';

Database link created

SQL>
明明Scott有这个权限的，为什么时候他还说没有呢？SYS是可以的，

千问 · 2008-11-27 14:56:58

SQL> create database link dl1 connect to scott identified by tiger using 'net1';
create database link dl1 connect to scott identified by tiger using 'net1'
ORA-01031: 权限不足
>>>需要检查你当前用户的权限.

千问 · 2008-11-27 14:56:58

SQL> select * from user_sys_privs;
USERNAME
PRIVILEGE
ADMIN_OPTION
------------------------- ---------------------------------------- ------------
SCOTT
CREATE DATABASE LINK
NO
SCOTT
UNLIMITED TABLESPACE
NO
这个就是显示了我当前用户就是Scott啊，有这个权限的啊，

千问 · 2008-11-27 14:56:58

Charele 发表于 2008-6-11 13:22
SQL> select * from user_sys_privs;
USERNAME
PRIVILEGE
...
问题是否解决了？

千问 · 2008-11-27 14:56:58

楼主的问题解决了吗？