UTL_FILE on shared folders - Oracle permission to write
First, sorry for my poor english.
I'm with this problem: once that I created and shared this folder on client, i want Oracle db, in another machine and with access to this shared folder, write files remotely.
I tryed to share this folder to "Everybody", to the database machine specifically, to authenticated users...
Testing in 4 different machines, with differents sharing types, I realize that some of them work and others won't.
And I know the problem is a OS permission thing.
I can't give, in production environment, permission to everybody. And some clients don't use a domain. Instead of it, they use a group (WORKGROUP, MSGROUP). So, I can't give specifically permissions.
In Oracle db, I have a function, which extract data and write this (using utl_file package) to a virtual folder called "Extrator".
First I created this folder on client.
Then, in "system" Oracle user, I executed this commands:
create or replace directory EXTRATOR as '\\ClientMachine\Extrator_IN;
grant read, write on directory EXTRATOR to INFO;
(The function resides in INFO user)
I know that OS "Administrator" account has permission to write in this shared folder.
And Oracle account, by default, is "Local System" OS user.
Right-Clicking on Oracle service, go to Log On tab, I can log on with OS Administrator user, but the database doesn't work after this change.
Is there another way to change the user authentication from "local system" to "administrator"???
Or if you have any other idea to give this user permission to write in shared folders, please, tell me.
Oracle 10g
Windows xp professional sp3 32 bit
Windows Server 2008 64 bit
Windows Seven 32 bi and another one 64 bit