Privilege Problem on SYS.DBMS_FILE_TRANSFER.PUT_FILE
I have security problem that I can't seem to find the answer to due to restrictions within my company.
I wrote a package owned by schema DPEADM that uses :
SYS.DBMS_FILE_TRANSFER.PUT_FILE(l_source_dirname, l_source_file, l_target_dirname, l_target_file, ls_DBLink);
This final parameter is a dbLink that is guaranteed to exist, but must the name must be created on the fly based on the target. If I run the package as the schema owner DPEADM, which is also who created the dbLink, it runs fine. If I run it as the user id DPE01 that I need to run it as, I get the error: ORA-02019: connection description for remote database not found.