Partition Creation Permissions

Поиск
Список
Период
Сортировка
От Samuel Nelson
Тема Partition Creation Permissions
Дата
Msg-id CAC7xaNc2CohGWv4=rp8fo6VwfETj+tTb3Vxu9KkQTgQSqt_mGw@mail.gmail.com
обсуждение исходный текст
Ответы Re: Partition Creation Permissions  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-general
Hi list!

I've been trying to restrict permissions of some users in our system and noticed that `create table foo partition of bar for values from (x) to (y)` complains that I must be the owner of the table.  Is there another GRANT I can give to my user to allow creation and dropping of partitions without allowing them to drop the parent table?

-Sam

https://github.com/nelsam

"As an adolescent I aspired to lasting fame, I craved factual certainty, and
I thirsted for a meaningful vision of human life -- so I became a scientist.
This is like becoming an archbishop so you can meet girls."
-- Matt Cartmill

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

Предыдущее
От: Ravi Krishna
Дата:
Сообщение: Re: vacuumdb not letting me connect to db
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: Partition Creation Permissions