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@xxxxxxxxxxxxx> wrote:
Suresh Raja <suresh.rajaabc@xxxxxxxxx> 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
