2 ms·
Observability, flexibility (I don't need to push a migration to change auth), SSO integration, and the ability to keep a clean separation between user and "mach
by throwanem 5y ago
Observability, flexibility (I don't need to push a migration to change auth), SSO integration, and the ability to keep a clean separation between user and "machine" (service, replication, etc) accounts.
- RedShift1 5y agoWhat does observability mean? Can you translate this into a concrete question? As for flexibility, do you mean authentication or authorization? SSO can be done at the SQL server level (MSSQL has it and so does Postgres, don't know about others), but handling the SSO part in your app and using "set role" and passing a user ID for your row level security policies to use is easier to set up and more flexible. Clean separation between user and machine accounts can absolutely be done with MSSQL and Postgres.