Why is keeping your password, port, host, and all secrets of a database (e.g. PostgreSQL) in the .Renviron file safe for Shiny apps and R scripts?
I have a question about the .Renviron file and its security password. Although the .Renviron file is a hidden file in our file system, how does it guarantee the security of passwords (key, token) and information?
I hope to understand the security against malicious hacking of the .Renviron file to guard the passwords and secrets important of the PostgreSQL database connection. In addition to omitting the explicit password in the R script.