List user who have access to schema

Suresh Raja <[email protected]>
Newsgroups gmane.comp.db.postgresql.general,gmane.comp.db.postgresql.sql
Message-ID <CAJP7dtAWGcS9qHFWnFZhyunheGHVnWU-3O=GetD9DNdpSCHqZQ@mail.gmail.com>
Hi All:

I'm looking for query which can list all users who have access to a
particular schema.
The user may be granted role, which is turn may have access to the schema.
If the schema name is sch1,

grant select on table sch1.tab1 to role_ro;
grant ALL on table sch1.tab1 to role_rw;

grant  role_ro to user1;
grant  role_rw to user2;

I'm looking for report like


Schema          |     Role             |    Username
------------------------------------------------------------------------
sch1                role_ro                  user1, user3
                       role_rw                  user2, user4


Thanks in advance,
-SR
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.