Hello,
We are setting up RStudio Server Pro on a RHEL 7 server. We want to allow users of the browser based RStudio IDE to connect to our Oracle database, but all queries executed against this Oracle database should be run against a service account.
After reading the article below, I'm wondering if there is a way to encrypt the password within the odbc.ini? If anyone could please clarify this for me, before I ask our RHEL Administrator to set this up.
https://db.rstudio.com/best-practices/drivers/
Thanks
Stuart