Re: Implications of having large number of users

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Implications of having large number of users
Дата
Msg-id 27398.1245851554@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Implications of having large number of users  ("Albe Laurenz" <laurenz.albe@wien.gv.at>)
Ответы Re: Implications of having large number of users  (Robert Haas <robertmhaas@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: "Albe Laurenz"
Дата:
Сообщение: Re: Implications of having large number of users
Следующее
От: Robert Haas
Дата:
Сообщение: Re: Implications of having large number of users