I noticed that the email and passwords for connectors are being stored in the same table as basic information about them. If we are actually going to eventually start using those emails and passwords for connector logins, we should create a separate table for authentication. The current DB setup is problematic since we are retrieving (and potentially exposing) passwords even when simply trying to get basic user data. This might be something worth doing even now as we wait for our actual DB to get set up if there are current auth functions that need to be updated to comply with this change.
I noticed that the email and passwords for connectors are being stored in the same table as basic information about them. If we are actually going to eventually start using those emails and passwords for connector logins, we should create a separate table for authentication. The current DB setup is problematic since we are retrieving (and potentially exposing) passwords even when simply trying to get basic user data. This might be something worth doing even now as we wait for our actual DB to get set up if there are current auth functions that need to be updated to comply with this change.