Passing DB credentials to a "global" pool connection in shiny?

[pieterjanvc]

Hi,

Did you read this post?

Shiny and Pool with database authentication prompts

I'm building a modularized Shiny app that uses a Pool connection to a SQL Server database. During development I'm pulling in my own SQL Server login credentials from a local .yaml file with the config package. I'm hoping to host the app in shinyapps.io and allow others in my organization to authenticate with their own SQL Server user/pass. I'm having difficulty figuring out how to prompt users for their credentials -- the Pool is created in the global.R file so it will be available to the various modules. Is there a way to put user/pass input fields in a module and pass the values back to the Pool connection string somehow? Or should I create the Pool somewhere else other than global.R to ma…

PJ