List user who have access to schema

Поиск
Список
Период
Сортировка
От Suresh Raja
Тема List user who have access to schema
Дата
Msg-id CAJP7dtAWGcS9qHFWnFZhyunheGHVnWU-3O=GetD9DNdpSCHqZQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: List user who have access to schema
Re: List user who have access to schema
Re: List user who have access to schema
Список pgsql-general
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



В списке pgsql-general по дате отправления: