Re: A function privilege problem

在 2019年7月25日，上午11:08，David G. Johnston <david.g.johnston@gmail.com> 写道：

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.