Re: A function privilege problem - Mailing list pgsql-bugs

From 高 云龙
Subject Re: A function privilege problem
Date
Msg-id FF5A0177-7087-4960-B74A-15BB0838F1D1@biss.com
Whole thread Raw
In response to Re: A function privilege problem  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-bugs
Thx for you , get it

在 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.

pgsql-bugs by date:

Previous
From: Andres Freund
Date:
Subject: Re: BUG #15923: Prepared statements take way too much memory.
Next
From: Michael Paquier
Date:
Subject: Re: BUG #15827: Unable to connect on Windows using pg_services.confusing Python psycopg2