How to list all the privileges a user has?

From: <kynn(at)panix(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: How to list all the privileges a user has?
Date: 2006-05-06 12:25:43
Message-ID: 200605061225.k46CPhM12142@panix3.panix.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

My apologies for all these questions. I hope this will be the last
one for a while.

I guess the subject line says it all: how does one list all the
privileges a given user has?

Thanks!

kj

I'm aware of functions like has_table_privilege(), etc., but they
don't do what I want.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Mingzuo Shen 2006-05-06 13:39:31 databases missing
Previous Message Tom Lane 2006-05-06 02:08:58 Re: Permission denied: LOCK TABLE test.__proc IN ACCESS SHARE MODE