Snapshot replicated tables/views owner question about mimeo HOT 2 CLOSED

The functions are run with the SECURITY DEFINER flag which means that they are run as whoever owns the function itself. This allows you to give execute permissions on the function so a role can run them and create replication tables but not have to give them blanket CREATE privileges on the entire database or schema.
Unfortunately that's not a flag that can just be turned on or off in a function. If you made your role the owner of the mimeo functions, then they would be the owner of the tables that are created. Not sure if that would work for you, but hope that at least clarifies how it works.
I'll look at seeing if maybe security definer is better to be off for the maker functions. I know it's definitely useful for the refresh functions since it allows roles to run refreshes but not have access to change the data in the destination tables themselves.

from mimeo.

Thank you for your prompt and detailed reply, this helped me out!

from mimeo.