pg_dump : problem with grant on table columns

Поиск
Список
Период
Сортировка
От Brice André
Тема pg_dump : problem with grant on table columns
Дата
Msg-id CAOBG12knSUvQc9vA4m=ixmRX14OqcuTccXShAfU30LkXtg98uA@mail.gmail.com
обсуждение исходный текст
Ответы Re: pg_dump : problem with grant on table columns  (Craig Ringer <ringerc@ringerc.id.au>)
Список pgsql-sql
Hello,<br /><br />I sometimes define some access rights on table columns instead of whole table. Everything works fine
exceptwhen I perform a dump.<br /><br />When I dump a databse that contains such access rights, the pg_dump utility
generatescommands like this one : <br /> GRANT SELECT("Login") ON TABLE "Clients" TO "AgendaSubscript";<br /><br />But,
whenI execute the content of this dump in a fresh database (for backup and restore stuff), those commands are rejected
andthus, my restored database has not the proper access rights.<br /><br />Is this a bug with the pg_dump tool or am I
doingsomething wrong ?<br /><br />Regards,<br /><br />Brice André<br /> 

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

Предыдущее
От: Jasen Betts
Дата:
Сообщение: Re: Updatable view should truncate table fields
Следующее
От: John Fabiani
Дата:
Сообщение: updating a sequence