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/ ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings