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: (view raw, whole thread or download thread mbox)
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,


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-2017 The PostgreSQL Global Development Group