Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: getting error on UTL_FILE.FOPEN
DA Morgan schrieb:
> Muthu Kumar G wrote: >
> > > Did you grant READ on the directory? > > And why would you choose the root? That is bad practice on any o/s. > > Working demos can be found in Morgan's Library at www.psoug.org > click on UTL_FILE.
From
http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_5007.htm#sthref5036
<quote>
When you create a directory, you are automatically granted the READ and
WRITE object privileges on the directory, and you can grant these
privileges to other users and roles. The DBA can also grant these
privileges to other users and roles.
</quote>
Best regards
Maxim Received on Thu Nov 10 2005 - 07:37:59 CST