Re: List user who have access to schema
"David G. Johnston" <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.general,gmane.comp.db.postgresql.sql |
|---|---|
| Message-ID | <CAKFQuwbdJnoO6DXa0Ax1jCVu=s4dA9RMr3kSShOc3Dz2aefBag@mail.gmail.com> |
On Thursday, August 2, 2018, Suresh Raja <[email protected]> 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.