我在test表上安装了一个触发器,在触发器中掉用了java的class。结果在修改test表时。出现以下异常。
SQL> update testset bm = 'aaaaa' where xh =3;
update testset bm = 'aaaaa' where xh =3
*
ERROR 位于第 1 行:
ORA-29532: Java call terminated by uncaught Java exception:
java.security.AccessControlException: the Permission (java.net.SocketPermission
172.31.0.12:1521 connect,resolve) has not been granted to SCOTT. The PL/SQL to
grant this is dbms_java.grant_permission( 'SCOTT',
'SYS:java.net.SocketPermission', '172.31.0.12:1521', 'connect,resolve' )
ORA-06512: at "SCOTT.TEST_TRIGGER", line 0
ORA-06512: at "SCOTT.TRIGGER_TEST", line 7
ORA-04088: error during execution of trigger 'SCOTT.TRIGGER_TEST'
是哪个权限我没有赋给scott呢?我请给出赋权限的具体的命令!
|