Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group