X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.2])
	by svr1.postgresql.org (Postfix) with ESMTP id 46945D1EF92
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon,  3 May 2004 14:56:12 -0300 (ADT)
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 71989-01
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon,  3 May 2004 14:55:56 -0300 (ADT)
Received: from curie.credativ.org (credativ.com [217.160.209.18])
	by svr1.postgresql.org (Postfix) with ESMTP id 40632D1EECD
	for <pgsql-sql@postgresql.org>; Mon,  3 May 2004 14:55:51 -0300 (ADT)
Received: from localhost (localhost [127.0.0.1])
	by curie.credativ.org (Postfix) with ESMTP
	id 3EF5555EF0; Mon,  3 May 2004 19:55:57 +0200 (CEST)
Received: from colt.pezone.net (dsl-082-082-239-156.arcor-ip.net
	[82.82.239.156]) (using TLSv1 with cipher RC4-MD5 (128/128 bits))
	(No client certificate requested)
	by curie.credativ.org (Postfix) with ESMTP
	id C4F3455EEC; Mon,  3 May 2004 19:55:56 +0200 (CEST)
From: Peter Eisentraut <peter_e@gmx.net>
To: Pallav Kalva <pkalva@deg.cc>, Tom Lane <tgl@sss.pgh.pa.us>
Subject: Re: [SPAM] Re: Permissions not working
Date: Mon, 3 May 2004 19:55:56 +0200
User-Agent: KMail/1.5.1
Cc: "scott.marlowe" <scott.marlowe@ihs.com>, pgsql-sql@postgresql.org
References: <Pine.LNX.4.33.0404291522430.10983-100000@css120.ihs.com>
	<13033.1083594203@sss.pgh.pa.us> <40965FD9.3020606@deg.cc>
In-Reply-To: <40965FD9.3020606@deg.cc>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200405031955.56052.peter_e@gmx.net>
X-Virus-Scanned: by AMaViS at credativ.com
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests=
X-Spam-Level: 
X-Archive-Number: 200405/14
X-Sequence-Number: 17728

Pallav Kalva wrote:
>     I tried both database privileges and table privileges (all and
> select) it still doesnt work. Not sure
> what is wrong here, I tried logging in as both postgres and usps user
> and both them doesnt work.

What about all those groups that have privileges?  Please post the 
output of \z when you try a revoke so we can verify what's going on.