X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 5AD7B540C9
	for <pgsql-interfaces-postgresql.org@localhost.postgresql.org>;
	Sun, 20 Mar 2005 16:01:52 +0000 (GMT)
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 12518-01
	for <pgsql-interfaces-postgresql.org@localhost.postgresql.org>;
	Sun, 20 Mar 2005 16:01:42 +0000 (GMT)
Received: from tigger.fuhr.org (tigger.fuhr.org [63.214.45.158])
	by svr1.postgresql.org (Postfix) with ESMTP id 67E425561A
	for <pgsql-interfaces@postgresql.org>;
	Sun, 20 Mar 2005 16:01:41 +0000 (GMT)
Received: from winnie.fuhr.org (winnie.fuhr.org [10.1.0.1])
	by tigger.fuhr.org (8.13.3/8.13.3) with ESMTP id j2KG1bOh028672
	(version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK);
	Sun, 20 Mar 2005 09:01:39 -0700 (MST)
	(envelope-from mfuhr@winnie.fuhr.org)
Received: from winnie.fuhr.org (localhost [127.0.0.1])
	by winnie.fuhr.org (8.13.3/8.13.3) with ESMTP id j2KG1bvD019000;
	Sun, 20 Mar 2005 09:01:37 -0700 (MST)
	(envelope-from mfuhr@winnie.fuhr.org)
Received: (from mfuhr@localhost)
	by winnie.fuhr.org (8.13.3/8.13.3/Submit) id j2KG1aCR018999;
	Sun, 20 Mar 2005 09:01:36 -0700 (MST) (envelope-from mfuhr)
Date: Sun, 20 Mar 2005 09:01:36 -0700
From: Michael Fuhr <mike@fuhr.org>
To: Bruno Wolff III <bruno@wolff.to>, Murray Cumming <murrayc@murrayc.com>,
	pgsql-interfaces <pgsql-interfaces@postgresql.org>
Subject: Re: Discovering privileges
Message-ID: <20050320160136.GA18952@winnie.fuhr.org>
References: <1088799354.3319.110.camel@murrayc_debian>
	<Pine.LNX.4.56.0407021856250.5008@screw>
	<1111330231.5820.4.camel@localhost.localdomain>
	<20050320155230.GA3935@wolff.to>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <20050320155230.GA3935@wolff.to>
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.004 tagged_above=0 required=5 tests=AWL
X-Spam-Level: 
X-Archive-Number: 200503/54
X-Sequence-Number: 5383

On Sun, Mar 20, 2005 at 09:52:30AM -0600, Bruno Wolff III wrote:

> In recent (7.4+ I think) versions of Postgres there are functions provided
> for testing access to tables.

According to the Release Notes, has_table_privilege() was introduced
in 7.2.  The other privilege-testing functions appear to have been
introduced in 7.3 (except has_tablespace_privilege(), which is new
in 8.0).

-- 
Michael Fuhr
http://www.fuhr.org/~mfuhr/