Re: List user who have access to schema

[Tom Lane]

Suresh Raja <suresh.raja...@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