How to get user's role?

Поиск
Список
Период
Сортировка
От Armen Rizal
Тема How to get user's role?
Дата
Msg-id 20040930032445.0FFFF32A131@svr1.postgresql.org
обсуждение исходный текст
Ответы Re: How to get user's role?
Список pgsql-general
Hi all,
 
I want to get what roles/groups that the current user is member of.
I tried to use the following commands but they both returned no rows.
 
SELECT * FROM information_schema.enabled_roles
SELECT * FROM information_schema.applicable_roles
 
Anybody know how to solve this ? or anybody has a certain
function that look up for user's roles/groups ?
 
Thanks in advanced,
 
Armen

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

Предыдущее
От: "Ed L."
Дата:
Сообщение: Re: 7.3.4 vacuum/analyze error
Следующее
От: Jeffrey Melloy
Дата:
Сообщение: Out of memory errors on OS X