utl_file privlieges

utl_file privlieges

Post by Carla Smi » Sat, 05 Sep 1998 04:00:00

Applications staff wants to let all users have execute privilege on the package
utl_file.  They have the sub-directories limited in each users oracle.ini file
and by not having execute, they are are facing the problem of giving out
the application password as the application logon id is the only one with
execute privileges.  I don't know enough about the package to know if
there is a problem granting the access.

we're oracle 7.3.3 on aix.
thanks for any help.

   -**** Posted from Supernews, Discussions Start Here(tm) ****-
http://www.supernews.com/ - Host to the World's Discussions & Usenet



   Does anyone know of a way to store the filehandle returned value from
UTL_FILE.FOPEN in a PL/SQL table ?


          type file_details is record
               (disp_pipe_id varchar2(20),
                disp_file_id utl_file.file_type);   <<<<=============
doesn't seem to like this bit ?!?!

          type tab_file_details is table of file_details
               index by binary_integer;

          rec_file_detail    tab_file_details;


   if rec_file_detail(rec_counter).disp_pipe_id = returnpipe then
        file_id := rec_file_detail(rec_counter).disp_file_id;
        file_open := utl_file.is_open(file_id);
        if file_open then
            anyerrors := 'File already open';
            exit ;
        end if;
    end if;

Sorry if it's a stupid question

Thanks in advance if it's not



or remove extra m in downham

2. DB online Synchronization?

3. UTL_FILE how to use utl_file.get_line

4. SQL Server cant manage a 30gig Database ?

5. UTL_FILE : Is it possible to use utl_file through network path ?

6. if( ExecuteTemplateFile == E_FAIL ) Yell("HELP!");

7. Q: Solution for bug 458336? (UTL_FILE.PUT() -> UTL_FILE.WRITE_ERROR)

8. DBCC PAGE command in SQL7

9. UTL_FILE-Equivalency

10. Help using UTL_FILE in Oracle stored procs

11. Synchronize File Acces via PL/SQL UTL_FILE Package

12. Re : UTL_FILE

13. Using UTL_FILE