Postgres Pro
Downloads
Home   >   mailing lists

Re: List user who have access to schema - Mailing list pgsql-general

From Suresh Raja
Subject Re: List user who have access to schema
Date
Msg-id CAJP7dtD_CdD_fK8dbFhy_oc7D=9JwxUz+EUQrxgibCyO416y3g@mail.gmail.com
Whole thread Raw
In response to Re: List user who have access to schema  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: List user who have access to schema
Re: List user who have access to schema
Re: List user who have access to schema
Re: List user who have access to schema
List pgsql-general
Tree view
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@sss.pgh.pa.us> wrote:
Suresh Raja <suresh.rajaabc@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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: List user who have access to schema
Next
From: "David G. Johnston"
Date:
Subject: Re: List user who have access to schema