X-Original-To: pgsql-sql-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 28BCC9FA2F7 for ; Mon, 26 Jun 2006 21:52:56 -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 54930-09 for ; Mon, 26 Jun 2006 21:52:41 -0300 (ADT) X-Greylist: delayed 00:22:07.404793 by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 37C699FACFE for ; Mon, 26 Jun 2006 21:52:42 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from pow.actarg.com (host25.actarg.com [209.180.91.25]) by svr4.postgresql.org (Postfix) with ESMTP id 5AEA25AF05F for ; Tue, 27 Jun 2006 00:30:33 +0000 (GMT) Received: from [192.168.5.50] (bateman.cc [65.73.113.56]) (authenticated bits=0) by pow.actarg.com (8.13.1/8.13.1) with ESMTP id k5R0UOpI007449 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO) for ; Mon, 26 Jun 2006 18:30:27 -0600 Message-ID: <44A06E04.5000206@actarg.com> Date: Mon, 26 Jun 2006 17:30:12 -0600 From: Kyle Bateman User-Agent: Mozilla Thunderbird 1.0.8-1.1.fc4 (X11/20060501) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: permissions from system catalogs Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: ClamAV 0.88/1564/Mon Jun 26 08:55:16 2006 on pow.actarg.com X-Virus-Status: Clean X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/275 X-Sequence-Number: 25511 Can anyone point me where to look in the system catalogs (or information schema) to determine in advance whether a given user (or the current user) will have select permission to a given table or view? Kyle