Is there an accepted way to request a runtime password that can be stored in a variable in the running kernel for a notebook? The idea here is when a user starts using a specific data source, it may require authentication. Username is pretty easy, but I want to be able to prompt a user at instantiation of a data source object for the password rather than have it stored in a password. Now, I could put it in a cell, but the idea is I want to be able to write a wrapper module for my org that allows any user running the same notebook, to have the exact same code in the notebook execute on the datasource with their individual credentials.
So I have notebook A
and I have users X and Y
User X creates the notebook, they do something like
myds = instantiatedOrgDS()
it reads the context of the user, and then prompts for the datasource password from the user. They enter it in a box that doesn't echo the password, it setups up the Data source into the object mysql
next celll:
results = myds.query("select * from the all_the_data")
now the notebook has examples where the results are the same, as are the queries. (as long as both users have access to the data source) but either user can run the notebook and get the same results.
The kicker is how to prompt for the password securely... any ideas?
Thanks
John