X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 589815294F for ; Mon, 18 Jul 2005 12:40:17 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 74939-09 for ; Mon, 18 Jul 2005 15:40:12 +0000 (GMT) Received: from perseverance.encs.concordia.ca (perseverance-96.encs.concordia.ca [132.205.96.94]) by svr1.postgresql.org (Postfix) with ESMTP id 0262A5298F for ; Mon, 18 Jul 2005 12:40:10 -0300 (ADT) Received: from [132.205.44.35] (IDENT:emilu@curacao.cs.concordia.ca [132.205.44.35]) by perseverance.encs.concordia.ca (8.12.11/8.12.11) with ESMTP id j6IFe6uL031082 for ; Mon, 18 Jul 2005 11:40:06 -0400 Message-ID: <42DBCD55.5080909@cs.concordia.ca> Date: Mon, 18 Jul 2005 11:40:05 -0400 From: Ying Lu User-Agent: Mozilla Thunderbird 1.0.2 (X11/20050317) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Pgsql-sql@postgresql.org Subject: About retrieving objects' priviledge info such as grantee & its privileges for a specific object (view, table, function, etc.) Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Scanned-By: MIMEDefang 2.43 on perseverance.encs.concordia.ca at 2005/07/18 11:40:06 EDT X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.012 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200507/152 X-Sequence-Number: 22130 Hello, May I know the commands to retrieve objects' privileges info please? Something like: Object Type, Object name, creator, grantee, privilege, is_creatable ===================================================== table T1 user1 user2 select, update, delete no table T1 user1 user3 select no view V1 user2 user4 select no P.S. (postgreSQL 8.0.1) Thanks a lot, Emi