#6 utl_file Permission

[Harbinder]

Hi,
On my new project I wanted to introduce utPlsql, but I found out that due to security reasons, we are not allowed access to utl_file. I was able to install utPlsql but the packages like UTGEN, UTASSERT2, UTPLSQL are compalining that 'UTL_FILE' must be declared. Is there a workaround around that.

Thanks in advance.

Harbinder

[Duane Dieterich]

connect as sys
grant execute on utl_file to utp;

[Paul Walker]

If they don't want you to have visibility of the utl_file package for security reasons, then I'm guessing you don't have enough access to run Duane's suggestion and the DBA's don't want to run it for you. In that case, I'm afraid I'm struggling to think of any way around that, sorry.

The only thing I'd mention is that as well as having visibility of the UTL_FILE package, access to the file system is controlled by things like the utl_file_dir control parameter or Oracle's Directory objects - by giving you this, they're not giving you completely unrestricted access to the file system.

I'll leave this open - maybe someone will think of something else that might help