I have a user that is executing some pl/sql. He opoens a file with UTL_FILE.FOPEN and then writes some things and closes the file. BUT the file is owned by unix user "oracle" with a group of "dba" ??!! He is running as user "mwallace" (both in unix and oracle sqlplus) ? When he tries to edit the file, he gets permission denied... Please help!
btw...If the user spools output it will go to a file which he owns.