Re: How to get user's role?

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/