Ah, I didn't realize that was an option on the function. They're already
being created by a trigger (the table is partitioned on a foreign key, so
partitions are created by a trigger on the referenced table); it sounds
like I can just update that trigger function with `security definer`.
-Sam
ht
On Thu, Feb 4, 2021 at 3:39 PM Samuel Nelson
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 m
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
