I have created a role that many users can share:
> create role foo_read_only connection limit 5;
I have then assigned permissions to that role:
> grant select on table1 to foo_read_only;
Then I have assigned that role to people:
> grant foo_read_only to fred; > grant foo_read_only to ginger;
Question: Do both fred and ginger get a connection limit of 5, or would that limit be shared between them?