X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id DDD239FA38E for ; Sat, 6 May 2006 09:25:50 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 72078-06 for ; Sat, 6 May 2006 09:25:46 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail3.panix.com (mail3.panix.com [166.84.1.74]) by postgresql.org (Postfix) with ESMTP id 1CBEB9F9431 for ; Sat, 6 May 2006 09:25:46 -0300 (ADT) Received: from panix3.panix.com (panix3.panix.com [166.84.1.3]) by mail3.panix.com (Postfix) with ESMTP id A768D13AADE; Sat, 6 May 2006 08:25:43 -0400 (EDT) Received: (from kynn@localhost) by panix3.panix.com (8.11.6p3/8.8.8/PanixN1.1) id k46CPhM12142; Sat, 6 May 2006 08:25:43 -0400 (EDT) Date: Sat, 6 May 2006 08:25:43 -0400 (EDT) Message-Id: <200605061225.k46CPhM12142@panix3.panix.com> From: To: pgsql-admin@postgresql.org Subject: How to list all the privileges a user has? X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/63 X-Sequence-Number: 21595 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.