Hi
A simple question before design.
Would there be performance issues having perhaps a million users, each
having several roles? I could imagine a user would have on average 10-20
roles.
Roles would be used to allow or restrict access to tables or rows
according to the business rules.
/kaare
Hi Dominique
Hi. Sure, that's a good point, and a best practice IMHO.
But I already do that, and the original question remain,
i.e. how does PostgreSQL with thousands or millions of roles?
Sorry if my original post was unclear, but I don't expect that there will be
much more than perhaps
Hi That said, having a million users is a bit strange. Do you want to give
each visitor to your website a unique Postgres role, or something like
that? I think this is unusual, but it should work.
OK, thanks for the feedback, all. It may not be necessary to have
such a fine grained syst
