Hi All,
We have many data files send from Oracle Database (18) to other divisions within the company. Most of the times, we create a dump file of the database or flat file and FTP to the server or put it in mapped server.
However the password of these servers change every 3 months and once in a while the server name changes once in every year .
Currently we have the windows batch file which has password and server name . Even though the access to these servers are limited, still it is a security threat.
What is the best way to handle this ?
My thoughts
Encrypt the password and server information in a database table. Dynamically generate the ftp server connection and password using a scheduled job. After the ftp is run, delete this file.
Provide schema access to the end user and let them connect via sql plus. Create a view for the data.
Appreciate your suggestions/ideas.
Thank tiy
Best Regards
Rajesh Alex