3 ms·
> and also permission, between True. That would also mean creating a database user for every application user. The auth service needs to attach more metadata t
by 0x777 10y ago
> and also permission, between
True. That would also mean creating a database user for every application user. The auth service needs to attach more metadata to the users and since postgres does not allow you to reference system catalogs, the two user systems have to be kept in sync. We were not quite certain how this idea of mapping users would pan out when we started building the auth service.
- ruslan_talpa 10y agoYou don't have to have a database user for each application user. Database roles are mapped to groups and application users are defined in tables as always and their ids can be used in RLS policies. It's hard to explain in a few words but the main point is that you don't need a database role to map to each application user