Re: SQL-standard function bodies and creating SECURITY DEFINER routines securely

2022-09-11 Thread Noah Misch
On Thu, Sep 08, 2022 at 01:20:31PM +0200, Peter Eisentraut wrote: > On 01.09.22 03:11, Bruce Momjian wrote: > >On Tue, Aug 16, 2022 at 03:38:13PM -0400, Bruce Momjian wrote: > >>On Tue, Aug 16, 2022 at 03:34:22PM -0400, Tom Lane wrote: > >>>Bruce Momjian writes: > I have written the attached p

Re: how to check specific user_name have “SELECT ON ALL TABLES IN SCHEMA ” privilege or not ?

2022-09-11 Thread David G. Johnston
On Sunday, September 11, 2022, yanliang lei wrote: > Dear everyone， > how to check specific have “SELECT ON ALL TABLES IN SCHEMA > ” privilege or not ? > This is not an appropriate list to ask general usage questions. We have a -general list for those. But, that isn’t a privilege. Its a gr

how to check specific user_name have “SELECT ON ALL TABLES IN SCHEMA ” privilege or not ?

2022-09-11 Thread yanliang lei
Dear everyone， how to check specific have “SELECT ON ALL TABLES IN SCHEMA ” privilege or not ?