Re: Must be owner to truncate?

Поиск
Список
Период
Сортировка
От Manfred Koizar
Тема Re: Must be owner to truncate?
Дата
Msg-id mkpog1982o9fn9qfmq8q9sf0jvlq04j5p3@4ax.com
обсуждение исходный текст
Ответ на Re: Must be owner to truncate?  (Andreas Seltenreich <andreas+pg@gate450.dyndns.org>)
Ответы Re: Must be owner to truncate?  (Stephen Frost <sfrost@snowman.net>)
Список pgsql-hackers
On Wed, 24 Aug 2005 07:01:00 +0200, Andreas Seltenreich
<andreas+pg@gate450.dyndns.org> wrote:
>However, a question arose quickly: According to the standard, revoking
>INSERT, UPDATE and DELETE after GRANT ALL PRIVILEGES would leave the
>relation read-only, but with the TRUNCATE privilege lying around, this
>would no longer be true for PostgreSQL.

I'd say that the TRUNCATE privilege includes DELETE, so that REVOKE
DELETE implicitly revokes TRUNCATE and GRANT TRUNCATE implicitly
grants DELETE.

ServusManfred



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

Предыдущее
От: Robert Treat
Дата:
Сообщение: Re: 8.1 release notes
Следующее
От: Stephen Frost
Дата:
Сообщение: Re: Must be owner to truncate?