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 <t...@sss.pgh.pa.us> wrote: > Suresh Raja <suresh.raja...@gmail.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 >
