Hi hackers!
While working on an extension I encountered a quite tricky question -
the extension (with functions in C) creates tables during function calls,
these tables must be protected from direct users' queries, at the same
time they must remain accessible for all functions of this extension
for all users allowed to use this extension.
Could you please advise or give some hint on what is the correct (and
secure) way to implement this?
Currently I use the owner of the extension as owner when creating
such a table inside the function, but maybe there are some pitfalls
in this kind of solution?
Thanks in advance.
-- Regards,
Nikita Malakhov
Postgres Professional
The Russian Postgres Company