Re: getting error on UTL_FILE.FOPEN

Muthu Kumar G wrote:
> 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.

Too much unless security isn't a concern.

I'd have granted READ, WRITE only to a single schema that is the owner of the stored procedure using UTL_FILE.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)