Re: List user who have access to schema
Suresh Raja <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.general,gmane.comp.db.postgresql.sql |
|---|---|
| Message-ID | <CAJP7dtD_CdD_fK8dbFhy_oc7D=9JwxUz+EUQrxgibCyO416y3g@mail.gmail.com> |
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 <[email protected]> wrote: > Suresh Raja <[email protected]> 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 >