PL/SQL (MOSC)

MOSC Banner

Privilege Problem on SYS.DBMS_FILE_TRANSFER.PUT_FILE

edited Sep 13, 2010 4:03AM in PL/SQL (MOSC) 4 commentsAnswered
Hi,

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. 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center