Thread: How to get user's role?

How to get user's role?

From
"Armen Rizal"
Date:
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

Re: How to get user's role?

From
Michael Fuhr
Date:
On Thu, Sep 30, 2004 at 10:26:41AM +0700, Armen Rizal wrote:
>
> 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

What version of PostgreSQL are you using?  Are you sure the current
user belongs to any groups?  What's the output of the following
queries?

SELECT current_user;
SELECT usename, usesysid FROM pg_user WHERE usename = current_user;
SELECT * FROM pg_group;

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/