| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | 高 云龙 <gaoyunlong(at)biss(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-25 03:08:34 |
| Message-ID: | CAKFQuwaiT4-7AtcdnEHRGq6O3j6UA2ya717PPQMzRP2cvg3weA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On Wednesday, July 24, 2019, 高 云龙 <gaoyunlong(at)biss(dot)com> wrote:
>
> > 在 2019年7月24日，上午10:09，yunlong <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 | Guyren Howe | 2019-07-25 05:52:33 | Re: Request for resolution || Support |
| Previous Message | Tom Lane | 2019-07-25 02:09:52 | Re: ADD CHECK fails for parent table if column used in CHECK is fully-qualified |