Re: Removing pg_auth_members.grantor (was Grantor name gets lost when grantor role dropped)

Поиск
Список
Период
Сортировка
От Stephen Frost
Тема Re: Removing pg_auth_members.grantor (was Grantor name gets lost when grantor role dropped)
Дата
Msg-id 20070504194145.GN1504@tamriel.snowman.net
обсуждение исходный текст
Ответ на Removing pg_auth_members.grantor (was Grantor name gets lost when grantor role dropped)  (Alvaro Herrera <alvherre@commandprompt.com>)
Ответы Re: Removing pg_auth_members.grantor (was Grantor name gets lost when grantor role dropped)  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-hackers
* Alvaro Herrera (alvherre@commandprompt.com) wrote:
> I took a look, and concluded that the only bit of code that uses the
> grantor at all is pg_dumpall.
>
> Does this means we can remove it altogether?  In back branches, we would
> take out the pg_dumpall code.

I don't have time right at the moment (leaving shortly and will be gone
all weekend) but what I would do is check the SQL standard, especially
the information schema, for any requirement to track the grantor.  Much
of what I did was based on the standard so that may have been the
instigation for tracking grantor.  Though, even without that, we track
the grantor of most other grants (possibly all currently?) and it seems
like a useful bit of information for DBAs to be able to know who granted
what to whom.

I can't say I've used it though, personally.  Of course, I'll be pretty
unhappy if a day comes when I do need it and it's not there. :)
Thanks,
    Stephen

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

Предыдущее
От: jaba the mobzy
Дата:
Сообщение: Re: Bitmap Heap Scan anomaly
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Removing pg_auth_members.grantor (was Grantor name gets lost when grantor role dropped)