Re: Including PL/PgSQL by default

Поиск
Список
Период
Сортировка
От Roberts, Jon
Тема Re: Including PL/PgSQL by default
Дата
Msg-id 1A6E6D554222284AB25ABE3229A9276271560A@nrtexcus702.int.asurion.com
обсуждение исходный текст
Ответ на Re: Including PL/PgSQL by default  (Andrew Dunstan <andrew@dunslane.net>)
Список pgsql-hackers
>
> Joshua D. Drake wrote:
> >
> > Notice that user foo is not a super user. Now I log into
> > PostgreSQL and connect to the postgres database (the super users
> > database) as the non privileged user "foo". The user "foo" in theory
> > has *zero* rights here accept that he can connect.
> >
> >
> >
>
> That's not true. The public schema has public UC privs, and always has
> had.
>

Is it safe to remove UC privs on the public schema?  Having rights to
"connect" should mean connect, not connect and create.


Jon


Jon


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

Предыдущее
От: Gregory Stark
Дата:
Сообщение: Re: VARATT_EXTERNAL_GET_POINTER is not quite there yet
Следующее
От: Andrew Sullivan
Дата:
Сообщение: Re: Including PL/PgSQL by default