Postgres Pro
Downloads
Home   >   mailing lists

How to get user's role? - Mailing list pgsql-general

From Armen Rizal
Subject How to get user's role?
Date
Msg-id 20040930032445.0FFFF32A131@svr1.postgresql.org
Whole thread Raw
Responses Re: How to get user's role?  (Michael Fuhr <mike@fuhr.org>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: "Ed L."
Date:
Subject: Re: 7.3.4 vacuum/analyze error
Next
From: Jeffrey Melloy
Date:
Subject: Out of memory errors on OS X