I created a user and gave him execute privileges for UTL_FILE
package. But it is not working. It seems this user doesn't have permissions for writting on to the unix directory specified. How can i add this user to any unix group so that he will able to write to that directory.
Thanks in advance.
The unix user that is writing to the directory is the oracle user. The oracle user must have write permission on that directory. Also, you must configure UTL_FILE_DIR in your init.ora file in order for utl_file to write...