Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Rights of Oracle 's files generated by UTL_FILE

Rights of Oracle 's files generated by UTL_FILE

From: Yann GRENET <blues92_at_free.fr>
Date: Wed, 15 Nov 2000 22:26:54 GMT
Message-ID: <O4EQ5.483$qQ1.916592@nnrp4.proxad.net> 






I am under ORACLE Server 7.3.4 and Unix HP-UX 10.20
How to specify rights on files generated by Oracle 's package UTL_FILE ?
By default, Oracle give its files the defaults rights of unix user "oracle".



No batch can be used after generation of the file. (so, no "chmod" or things
like this...)



The only solution I have found is to give the maximum of rights to the user
"oracle" :


in file ".profile" : umask 000



Not so good for security I guess ! ;-(



Do you have other ideas ?



Thanks in advance.
Received on Wed Nov 15 2000 - 16:26:54 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US