Re:PostgreSQL 10.2 Released
by pritambaral on Friday February 09, 2018 @03:00PM
(#16343371)
> Doesn't putting function in different schemas mean you have to grant select/update permissions to the schemas that talk to other schemas?
In Pg, schemas don't talk to schemas. When a function is run, it runs with the privilege level of either the user that called it, or the user that defined it.
In Pg, schemas don't talk to schemas. When a function is run, it runs with the privilege level of either the user that called it, or the user that defined it.