Home » SQL & PL/SQL » SQL & PL/SQL » UTL_FILE permission
UTL_FILE permission [message #1105] Mon, 01 April 2002 11:32 Go to next message
satish
Messages: 112
Registered: September 2000
Senior Member
can any one know how to set up the utl_file permissions so that I can create files on my host o.s
i have db on unix box and and i am using sqlplus
i need to create utl_files on my n.t os

Report message to a moderator

Re: UTL_FILE permission [message #1110 is a reply to message #1105] Tue, 02 April 2002 04:15 Go to previous message
Epe
Messages: 99
Registered: March 2002
Member
Hello,

you have to put the "UTL_FILE_DIR" initialization parameter in your parameter file (initX.ora).
If you want more directories to be accessable, repeat the parameter. Beware, don't put any other parameters between different utl_file_dir parameters, or only the last utl_file_dir will be read.
If you want, you can set utl_file_dir = *, but that means that everyone can access every directory... : be carefull with that.
See Oracle Manuals :
"http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76961/ch1188.htm#7036"

Success,

epe

Report message to a moderator

Previous Topic: buffer over flows
Next Topic: RE: Tablespace usage
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Apr 20 06:19:44 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.