Re: List user who have access to schema

yes ... how can i pass variable * to the function has_schema_privilege(*,
'schema-of-interest', 'usage');

Thanks!

On Thu, Aug 2, 2018 at 12:58 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Suresh Raja <suresh(dot)rajaabc(at)gmail(dot)com> writes:
> > I'm looking for query which can list all users who have access to a
> > particular schema.
>
> Something involving
>
> SELECT ... FROM pg_user
> WHERE has_schema_privilege(usename, 'schema-of-interest', 'usage');
>
> would probably be what you want.
>
> regards, tom lane
>