dojjol
asked on
dbms_java.grant_permission java.io.permissiom
Hello All,
I have a file at network called //CCEdit/english/my.txt. I have a javastoredprocedure, (basically a java class loaded as a function).
When I execute the procedure it says
java.security.AccessContro lException : the Permission (java.io.FilePermission /CCEDIT/english/my.text read),
Even if I have executed the
dbms_java.grant_permission ( 'SCOTT', 'SYS:java.io.FilePermissio n', '/CCEDIT/english/my.text', 'read' ). It still complains for the same error.
I have a file at network called //CCEdit/english/my.txt. I have a javastoredprocedure, (basically a java class loaded as a function).
When I execute the procedure it says
java.security.AccessContro
Even if I have executed the
dbms_java.grant_permission
ASKER
u mean oracle user or oracle.
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
Is that one leading slash ("/") or two ("//")? You used both in different places in your question.
The owner (the O/S user account) of the Oracle database software will need to have read permission on this file before you can grant permission in the database with dbms_java. From the database server, does the owner of the Oracle software have permission to see and read this file?
The owner (the O/S user account) of the Oracle database software will need to have read permission on this file before you can grant permission in the database with dbms_java. From the database server, does the owner of the Oracle software have permission to see and read this file?
ls -al /CCEDIT/english/my.text