Re: List user who have access to schema

Tom Lane <[email protected]> Thu, 02 Aug 2018 13:58:37 -0400

Newsgroups	gmane.comp.db.postgresql.sql,gmane.comp.db.postgresql.general
Message-ID	<[email protected]>

Suresh Raja <[email protected]> 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