Re: [BUGS] BUG #14456: pg_dump doesn't restore permissions on tables belonging to an extension

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [BUGS] BUG #14456: pg_dump doesn't restore permissions on tables belonging to an extension
Дата
Msg-id 13549.1484248592@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #14456: pg_dump doesn't restore permissions on tables belonging to an extension  (daniele.varrazzo@gmail.com)
Ответы Re: [BUGS] BUG #14456: pg_dump doesn't restore permissions on tablesbelonging to an extension  (Stephen Frost <sfrost@snowman.net>)
Re: [BUGS] BUG #14456: pg_dump doesn't restore permissions on tablesbelonging to an extension  (Stephen Frost <sfrost@snowman.net>)
Re: [BUGS] BUG #14456: pg_dump doesn't restore permissions on tablesbelonging to an extension  (Stephen Frost <sfrost@snowman.net>)
Список pgsql-bugs
Stephen Frost <sfrost@snowman.net> writes:
> * Tom Lane (tgl@sss.pgh.pa.us) wrote:
>> Hmm.  There's an argument to be made that ALTER EXTENSION ADD should
>> absorb whatever the object's current ACLs are into the pg_init_privs
>> entries for the extension.  (I don't think it does that now, though
>> I might be wrong.)  However ...

> I've not gone and looked yet, but I doubt that it does.  I think I can
> agree with the argument that it really should add those ACLs to
> pg_init_privs.  Of course, any furhter manipulation of the ACLs from
> that point will cause those ACLs to be included in the pg_dump.

> I'll take a look at ALTER EXTENSION ADD and pg_init_privs.

By the same token, does ALTER EXTENSION DROP remove those entries?

            regards, tom lane


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

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

Предыдущее
От: Moshe Jacobson
Дата:
Сообщение: Re: [BUGS] BUG #14456: pg_dump doesn't restore permissions on tablesbelonging to an extension
Следующее
От: Stephen Frost
Дата:
Сообщение: Re: [BUGS] BUG #14456: pg_dump doesn't restore permissions on tablesbelonging to an extension