Postgres Pro
Downloads
Home   >   mailing lists

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

From David G. Johnston
Subject Re: List user who have access to schema
Date
Msg-id CAKFQuwbdJnoO6DXa0Ax1jCVu=s4dA9RMr3kSShOc3Dz2aefBag@mail.gmail.com
Whole thread Raw
In response to Re: List user who have access to schema  (Suresh Raja <suresh.rajaabc@gmail.com>)
List pgsql-general
Tree view
On Thursday, August 2, 2018, Suresh Raja <suresh.rajaabc@gmail.com> wrote:
yes ... how can i pass variable * to the function   has_schema_privilege(*, 'schema-of-interest', 'usage');

You cannot...you must execute the function once for every user, hence the original query's from clause.

David J.

pgsql-general by date:

Previous
From: Suresh Raja
Date:
Subject: Re: List user who have access to schema
Next
From: Adrian Klaver
Date:
Subject: Re: List user who have access to schema