'Encrypt the password in R
Is there a way to encrypt the password in R. I am connecting the database using OBDC connection string. So, when I pass the parameters, I will have to give the password as well as shown below. Can we hide this?
conn <- odbcDriverConnect(connection = "Driver=/aaa/bbb/ccc.so;HOST=POIII.fda.gfd.vin.com;PORT=1001;UID=vipra;PWD=password",believeNRows = FALSE, rows_at_time = 1)
Expected output
conn <- odbcDriverConnect(connection = "Driver=/aaa/bbb/ccc.so;HOST=POIII.fda.gfd.vin.com;PORT=1001;UID=vipra;PWD=*******",believeNRows = FALSE, rows_at_time = 1)
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|