For one of my databases, I have a developer requesting permission to $OH/bin to be able to load external tables.
Or, he says, for me to install a separate Oracle client on the same server.
REFERENCE: This is for Oracle 11.2.0.4, EE, on Linux 5.9.
So, what is the best practice here?
I remember back several years, I had set the sticky bit (SUID) on certain Oracle binary executables for developers. But that was back in Oracle 7 and 8. I have not heard of anyone doing that in years, so wondered what is the most appropriate way to give the user access to use the Oracle_Loader Access Driver (not sqlldr) to load external tables on the same server with the database? Or perhaps, he may want to use datapump to load. I'm not sure yet, but I'd like to know about the way to do this without compromising security of the Oracle software files.
If I were to install the Oracle client on the same server with the Oracle RDBMS, that seems redundant and improper.
It seems I can/should be able to set sticky bit or something like this.
I've read a few Oracle documents on this, but they do not seem to explain how to configure it so that a developer can load data.
I plan to create a directory on the server that I will give him access to the directory at the OS level, as well as read,write access within the database.
But how does he access the Oracle executables to load the data to/from the external tables?