On Wednesday, July 24, 2019, 高 云龙 <
gaoyunlong@biss.com> wrote:
> 在 2019年7月24日,上午10:09,yunlong <gaoyunlong@biss.com> 写道:
>
> What’s PUBLIC mean ? public schema ?
> My function is not in public schema, and I still can execute the function with the new db user after run revoke execute on function xxx from xxx
>
PUBLIC here is referring to the system group that all roles are implicitly and permanently members of.
You need to replace xxx with actual values and a self-contained script if you want others to understand what is being questioned.
David J.