Re: Can I check if somebody is superuser in stored procedure?

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: Can I check if somebody is superuser in stored procedure?
Дата
Msg-id 1302117188.14384.4.camel@vanquo.pezone.net
обсуждение исходный текст
Ответ на Re: Can I check if somebody is superuser in stored procedure?  (Jim Nasby <jim@nasby.net>)
Список pgsql-hackers
On ons, 2011-04-06 at 09:51 -0500, Jim Nasby wrote:
> Note that doesn't work if the user has superuser because it was granted via another role.

You can only be a superuser if your own superuser bit is set.  It cannot
be granted via some other role.  (Not sure whether that's a feature.)



В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Should psql support URI syntax?
Следующее
От: Dan Ports
Дата:
Сообщение: Re: getting to beta