DBMS_Java.GRANT_PERMISSION() problem, NT 4.0, shared drives

From: gnn_gnn <gnn_gnn_at_hotmail.com>
Date: Tue, 27 Mar 2001 01:40:34 -0500
Message-ID: <99pcdo$2uh$1@slb3.atl.mindspring.net>

Hi:

I have a Java stored procedure that is given a directory (e.g.,
'C:/Temp/Mike/') and a filename (e.g., 'foo.txt') (forgive me if I got the
'/' wrong in the example, that isn't the problem in the code). The
procedure writes to a new file of the given name in the given path. I use DBMS_JAVA.GRANT_PERMISSION() to grant 'read,write' to the DB User and it works fine IF I give it a local drive (NT 4.0) If I give it a shared drive like 'E:/Temp/mydir/' I get a java io error 'FileNotFound'. Anyone know why? I SUSPECT it might be that shares in existance depend on who is logged in, and the files are written by some admin user on behalf of the real user. What do I need to do to write to a shared folder on NT with such a stored procedure?

Thanks,

Mike Received on Tue Mar 27 2001 - 00:40:34 CST