How to get user's role?

From: "Armen Rizal" <armenrz(at)starprise(dot)net>
To: <pgsql-general(at)postgresql(dot)org>
Subject: How to get user's role?
Date: 2004-09-30 03:26:41
Message-ID: 20040930032445.0FFFF32A131@svr1.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Randall Smith 2004-09-30 03:34:33 initdb on Debian
Previous Message Ed L. 2004-09-30 03:18:24 Re: 7.3.4 vacuum/analyze error