Re: Converting from single user w/pool to multiple users - Mailing list pgsql-general

From Tom Lane
Subject Re: Converting from single user w/pool to multiple users
Date
Msg-id 27320.1111680999@sss.pgh.pa.us
Whole thread Raw
In response to Re: Converting from single user w/pool to multiple users  (Jeff Amiel <jamiel@istreamimaging.com>)
List pgsql-general
Jeff Amiel <jamiel@istreamimaging.com> writes:
> Could we continue to use our existing connection pool (via our app
> server) and every time the application 'gets' a connection (as a
> superuser) , we then 'SET SESSION AUTHORIZATION' to the appropriate user
> who is performing the action?

That would work to the extent that you filter SQL commands so a
nefarious user can't issue his own 'SET SESSION AUTHORIZATION'
to become someone else ...

            regards, tom lane

pgsql-general by date:

Previous
From: Jeff Amiel
Date:
Subject: Re: Converting from single user w/pool to multiple users
Next
From: Tom Lane
Date:
Subject: Re: Converting from single user w/pool to multiple users