privileges for many people, but many different
privileges for a few people.
Does it come down to performance issues when there are many roles to users?
On Wed, 2 Oct 2019 at 21:03, Rob Sargent wrote:
>
>
> On Oct 2, 2019, at 3:41 AM, Matt Andrews
> wrote:
>
> I have little exper
, maybe earlier.
>
> While this seems plausible- I'd love to hear about exactly what you've
> seen start to be a problem when getting up to that many users. Are you
> just referring to things like \du? Or..?
>
> Thanks,
>
> Stephen
>
--
Matt Andrews
0400 990 131
app users through a
connection pool.
I’m thinking that any queries should start with SET ROLE ‘username’ and end
with RESET ROLE. Is this how it could work?
Any help would be greatly appreciated.
--
Matt Andrews
0400 990 131
1
On Wed, Sep 25, 2019 at 2:54 PM Tom Lane wrote:
> Matt Andrews writes:
> > I'm trying to map view columns to their source columns using the system
> > catalogs and information schema, but not having much luck. It's easy to
> > determine which columns a vie
t want to manipulate the
returned data based on the types/constraints of the underlying columns of
the view.
It seems like mapping view columns to their source columns should be
something that's been done before. Is it possible?
Matt Andrews
0400 990 131