Link to home
Create AccountLog in
Avatar of dojjol
dojjolFlag for Afghanistan

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.AccessControlException: the Permission (java.io.FilePermission /CCEDIT/english/my.text read),

Even if I have executed the
dbms_java.grant_permission( 'SCOTT', 'SYS:java.io.FilePermission', '/CCEDIT/english/my.text', 'read' ). It still complains for the same error.
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Does oracle have read access on it?

ls -al /CCEDIT/english/my.text
Avatar of dojjol

ASKER

u mean oracle user or oracle.
ASKER CERTIFIED SOLUTION
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer
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?