| From: | 高 云龙 <gaoyunlong(at)biss(dot)com> |
|---|---|
| To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: A function privilege problem |
| Date: | 2019-07-26 03:56:17 |
| Message-ID: | FF5A0177-7087-4960-B74A-15BB0838F1D1@biss.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
Thx for you , get it
在 2019年7月25日，上午11:08，David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com<mailto:david(dot)g(dot)johnston(at)gmail(dot)com>> 写道：
On Wednesday, July 24, 2019, 高 云龙 <gaoyunlong(at)biss(dot)com<mailto:gaoyunlong(at)biss(dot)com>> wrote:
> 在 2019年7月24日，上午10:09，yunlong <gaoyunlong(at)biss(dot)com<mailto:gaoyunlong(at)biss(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Paquier | 2019-07-26 04:58:08 | Re: BUG #15827: Unable to connect on Windows using pg_services.conf using Python psycopg2 |
| Previous Message | Andres Freund | 2019-07-26 02:16:36 | Re: BUG #15923: Prepared statements take way too much memory. |