Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: getting error on UTL_FILE.FOPEN
Muthu Kumar G schrieb:
> CREATE OR REPLACE DIRECTORY MY_OUT AS '/export/home/mig10g/muthu';
>
> GRANT READ, WRITE ON DIRECTORY MY_OUT TO PUBLIC;
>
> are these permissions enough or should i give some more privileges.
>
> thanks.
> Muthu Kumar.
>
If you would have a look into documentation http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_9013.htm#i2077938 you will easily realise, that for a paricular directory object there are *no more* privileges available.
Best regards
Maxim Received on Thu Nov 10 2005 - 23:07:30 CST