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: | Raw Message | Whole Thread | 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 |