Home > mailing lists

How to get user's role? - Mailing list pgsql-general

From	Armen Rizal
Subject	How to get user's role?
Date	September 30, 2004 07:25:31
Msg-id	20040930032445.0FFFF32A131@svr1.postgresql.org Whole thread Raw
Responses	Re: How to get user's role?
List	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

From: "Ed L."
Date: 30 September 2004, 07:20:29
Subject: Re: 7.3.4 vacuum/analyze error

From: Jeffrey Melloy
Date: 30 September 2004, 07:50:10
Subject: Out of memory errors on OS X