Re: List user who have access to schema

[Tom Lane <tgl@xxxxxxxxxxxxx>]

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