Pin code or other security for production connections
I am a careful person who does not like to have connections to production environments beyond the exact time scope I need them.
But it also sucks to constantly set up and delete connections.
Currently I have set up a read only user on sql server which partially solves this but for any third party managing to access my computer it still means they can read and query data.
But at least it solves me writing to a production database by accident.
However, if we could have a connection that required authentication something like pin, fingerprint or similar and that times out somewhat quickly would solve both my annoyance at setting up and then removing a connection every time I want to write to the db manually and also that it does not need to leave connections open long term even in read only mode, mitigating the risk somewhat if someone accesses my computer.
I can imagine many solutions, such as "unlocked until screensaver" or timeout or similar