JOB运行时报ORA_06512错误.
JOB功能:把符合条件的数据通过DBLink插入另一个数据中.
怎么看SQL code都没有问题,用sqlplus运行ORA-01031: insufficient privileges.
用户在相应的表上有insert权限,仅insert权限,授予select权限后问题解决
insert权限下select权限相关?
下面是一个测试
测试一:
SQL> conn oak
Enter password:
Connected.
SQL> create table test1(id number);
Table created.
SQL> grant insert on test1 to test;
Grant succeeded.
SQL> conn test
Enter password:
Connected.
SQL> insert into oak.test1 values(10);
1 row created.
上面测试说明对local table的insert权限不需要select权限
测试二:
SQL> create public database link t connect to test identified by test using 'fpctest';
Database link created.
SQL> insert into oak.test1@t values(10);
insert into oak.test1@t values(10)
*
ERROR at line 1:
ORA-01031: insufficient privileges
ORA-02063: preceding line from T
上面的测试说明只有insert权限不能插入数据
SQL> grant select on oak.test1 to test;
Grant succeeded.
再次执行insert操作
SQL> insert into oak.test1@t values(10);
1 row created.
上面的测试说明对remote table的insert的操作需要insert,select权限同时拥有
同样要对remote table进行update,delete操作也需要select权限
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7419833/viewspace-600242/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/7419833/viewspace-600242/