Re: Implications of having large number of users - Mailing list pgsql-performance

From Tom Lane
Subject Re: Implications of having large number of users
Date
Msg-id 27398.1245851554@sss.pgh.pa.us
Whole thread Raw
In response to Re: Implications of having large number of users  ("Albe Laurenz" <laurenz.albe@wien.gv.at>)
Responses Re: Implications of having large number of users
List pgsql-performance
"Albe Laurenz" <laurenz.albe@wien.gv.at> writes:
> Robert Haas wrote:
>> I don't think this is true.  You can use SET SESSION AUTHORIZATION,
>> right?

> You are right, I overlooked that.
> It is restricted to superusers though.

That sort of thing is only workable if you have trustworthy client code
that controls what queries the users can issue.  If someone can send raw
SQL commands then he just needs to do RESET SESSION AUTHORIZATION to
become superuser.

            regards, tom lane

pgsql-performance by date:

Previous
From: "Albe Laurenz"
Date:
Subject: Re: Implications of having large number of users
Next
From: Robert Haas
Date:
Subject: Re: Implications of having large number of users