X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 2A563D1D2E7 for ; Fri, 6 Feb 2004 14:36:03 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 24486-02 for ; Fri, 6 Feb 2004 10:36:02 -0400 (AST) Received: from trieste.lan.lexum.pri (ravenna.LEXUM.UMontreal.CA [132.204.136.56]) by svr1.postgresql.org (Postfix) with ESMTP id E512BD1D2A0 for ; Fri, 6 Feb 2004 10:35:58 -0400 (AST) Received: from lexum.umontreal.ca (localhost [127.0.0.1]) by trieste.lan.lexum.pri (Postfix) with ESMTP id 00C53132358 for ; Fri, 6 Feb 2004 09:39:24 -0500 (EST) Message-ID: <4023A71C.2090603@lexum.umontreal.ca> Date: Fri, 06 Feb 2004 09:39:24 -0500 From: =?ISO-8859-1?Q?Fr=E9d=E9ric_M=E9dery?= User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.4) Gecko/20030630 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Postgres-Admin Mailing List Subject: List all user rights ? Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/75 X-Sequence-Number: 12249 Is there a way to list user rights on a database ? I know that I can view use permission on earch table on a database. Bit what if I want to see all permission of userA ? is listing all tables permissions the only way ? thanks, F