How to get the users name from users group?

Поиск
Список
Период
Сортировка
От Jignesh Shah
Тема How to get the users name from users group?
Дата
Msg-id c11950271002190106n11de9142u113edb45fc1ada4a@mail.gmail.com
обсуждение исходный текст
Ответы Re: How to get the users name from users group?  (Magnus Hagander <magnus@hagander.net>)
Список pgsql-general
Hello All,

I have created role "database-users" and inserted some of users inside it. Could you tell me which query to use for listing out those users name? I went through pg_users, pg_group but no luck.

CREATE ROLE database-users
  NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE;

CREATE ROLE "dbuser1" LOGIN
  NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE;
GRANT database-users TO "dbuser1";

CREATE ROLE "dbuser2" LOGIN
  NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE;
GRANT database-users TO "dbuser2";

How to query database-users to list the dbuser1 and dbuser2?

Thanks in advance,
Jack

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

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: Getting number of affected row after performing update
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: PERFORM not working properly, please help..