| java privs to delete files ? [message #36361] |
Tue, 20 November 2001 05:43  |
Alexandre
Messages: 6
Registered: November 2001
|
Junior Member |
|
|
i encountered problems with a java stored procedure.
it has to delete files (the error is ora-29532).
i have another one which work fine because it only
neads 'read privs' ... so i'm not sure to understand
how to grant
- files are located at 'c:temp'
- java procedure is owned by 'XX'
- i set theses privs :
grant JAVAUSERPRIV to XX
grant JAVASYSPRIV to XX
exec dbms_java.grant_permission(
'XX','java.io.FilePermission',
'c:temp','read,write,delete')
any idea ?
thanks for reply
Alexandre
----------------------------------------------------------------------
|
|
|
|
| Re: java privs to delete files ? [message #36363 is a reply to message #36361] |
Tue, 20 November 2001 16:04  |
andrew again
Messages: 2577
Registered: March 2000
|
Senior Member |
|
|
If it is a Java stored procedure and "oracle" is the owner of the oracle processes, then "oracle" needs to be able to delete the files, not the user. The user in internal to Oracle, the OS only knows about the process owner which presumably has the oracle server as it's parent.
----------------------------------------------------------------------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
