Re: Partition Creation Permissions
| От | David G. Johnston |
|---|---|
| Тема | Re: Partition Creation Permissions |
| Дата | |
| Msg-id | CAKFQuwZG2P3ZoC8Q_6MfZzBrTNtKsNTHpD+wMGzbpNzY8_x2DA@mail.gmail.com обсуждение исходный текст |
| Ответ на | Partition Creation Permissions (Samuel Nelson <valczir.darkvein@gmail.com>) |
| Ответы |
Re: Partition Creation Permissions
|
| Список | pgsql-general |
On Thu, Feb 4, 2021 at 3:39 PM Samuel Nelson <valczir.darkvein@gmail.com> wrote:
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?
I doubt it...might want to consider writing a security definer function that you can give them permission to run instead of having them do things directly.
David J.
В списке pgsql-general по дате отправления: