Re: List user who have access to schema
От
Suresh Raja
Тема
Re: List user who have access to schema
Дата
Msg-id
CAJP7dtD_CdD_fK8dbFhy_oc7D=9JwxUz+EUQrxgibCyO416y3g@mail.gmail.com
Ответ на
Re: List user who have access to schema (Tom Lane)
Список
Дерево обсуждения
List user who have access to schema Suresh Raja <suresh.rajaabc@gmail.com>
Re: List user who have access to schema pinker <pinker@onet.eu>
Re: List user who have access to schema Tom Lane <tgl@sss.pgh.pa.us>
Re: List user who have access to schema Suresh Raja <suresh.rajaabc@gmail.com>
Re: List user who have access to schema Adrian Klaver <adrian.klaver@aklaver.com>
Re: List user who have access to schema "David G. Johnston" <david.g.johnston@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 <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 по дате отправления
