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 D990D9FB3A6
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Thu, 20 Jul 2006 16:54: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 59841-03-5 for <pgsql-sql-postgresql.org@postgresql.org>;
	Thu, 20 Jul 2006 16:54:56 -0300 (ADT)
X-Greylist: delayed 00:28:46.378477 by SQLgrey-
Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159])
	by postgresql.org (Postfix) with ESMTP id 76C1B9FB228
	for <pgsql-sql@postgresql.org>; Thu, 20 Jul 2006 11:26:13 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3
Received: from tamar.dmr.co.uk (tamar.dmr.co.uk [195.112.52.166])
	by svr4.postgresql.org (Postfix) with ESMTP id 70A2C5AF069
	for <pgsql-sql@postgresql.org>; Thu, 20 Jul 2006 13:57:10 +0000 (GMT)
Received: from HFPORT.dmr.co.uk (pennsoft.gotadsl.co.uk [81.6.232.68])
	by tamar.dmr.co.uk (8.13.5/8.13.5) with ESMTP id k6KDujZb026472;
	Thu, 20 Jul 2006 14:56:46 +0100
Message-Id: <5.1.0.14.0.20060720145514.03833140@mailserver.dmr.co.uk>
X-Sender: hf1@mailserver.dmr.co.uk
X-Mailer: QUALCOMM Windows Eudora Version 5.1
Date: Thu, 20 Jul 2006 15:01:59 +0100
To: pgsql-sql@postgresql.org
From: Hilary Forbes <hforbes@dmr.co.uk>
Subject: Help with privilages please
Mime-Version: 1.0
Content-Type: text/html; charset="us-ascii"
X-Archive-Number: 200607/263
X-Sequence-Number: 25837

<html>
Dear All<br><br>
We are running pg v 7.4.1 and importantly the database has been converted
from earlier versions of pg (6.5 I seem to recall).<br><br>
I have an existing table suppliers and I have created a new user
'hilary'<br><br>
REVOKE ALL on TABLE suppliers FROM hilary;<br><br>
now login as hilary<br>
SELECT * from suppliers;<br>
and I get all the records!!!<br><br>
If I create a **new** table though and then do the above, the permissions
work I get a polite message telling me &quot;no go&quot;.&nbsp; This
sounds to me like a problem with earlier compatibility.&nbsp; Is there a
way I can overcome this.&nbsp; A simple dump/restore does not solve the
problem.<br><br>
Many thanks<br>
Hilary<br>
<x-sigsep><p></x-sigsep>
Hilary Forbes<br>
DMR Limited (UK registration 01134804) <br>
A DMR Information and Technology Group company
(<a href="http://www.dmr.co.uk/" eudora="autourl"><font color="#0000FF"><u>www.dmr.co.uk</a></u></font>)
<br>
Direct tel 01689 889950 Fax 01689 860330 <br>
DMR is a UK registered trade mark of DMR Limited<br>
**********************************************************</html>