Home » RDBMS Server » Security » java privs to delete files ?
java privs to delete files ? [message #36361] Tue, 20 November 2001 05:43 Go to next message
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 Go to previous message
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.

----------------------------------------------------------------------
Previous Topic: Limited Amount of Roles Available
Next Topic: OS level authentication
Goto Forum:
  


Current Time: Thu Mar 28 13:48:12 CDT 2024