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 995C3D1EF86 for ; Mon, 3 May 2004 15:23:53 -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 75306-08 for ; Mon, 3 May 2004 15:23:33 -0300 (ADT) Received: from mail.deg.cc (mail.deg.cc [198.70.16.196]) by svr1.postgresql.org (Postfix) with ESMTP id 2C4C7D1EF9D for ; Mon, 3 May 2004 15:23:28 -0300 (ADT) Received: from deg.cc (barney.deg.cc [198.70.16.205]) by mail.deg.cc (Postfix) with ESMTP id 43C0C55F8A; Mon, 3 May 2004 14:23:29 -0400 (EDT) Message-ID: <40968F43.1060305@deg.cc> Date: Mon, 03 May 2004 14:28:19 -0400 From: Pallav Kalva User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.4.2) Gecko/20040308 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Peter Eisentraut Cc: Tom Lane , "scott.marlowe" , pgsql-sql@postgresql.org Subject: Re: [SPAM] Re: Permissions not working References: <13033.1083594203@sss.pgh.pa.us> <40965FD9.3020606@deg.cc> <200405031955.56052.peter_e@gmx.net> In-Reply-To: <200405031955.56052.peter_e@gmx.net> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit 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/15 X-Sequence-Number: 17729 Peter Eisentraut wrote: >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. > here is the output. This is the same output, this output doesnt change at all. usps=> \z citystate_alias Access privileges for database "usps" Schema | Table | Access privileges --------+-----------------+----------------------------------------------------------------------------------------------------------------------- public | citystate_alias | {postgres=a*r*w*d*R*x*t*/postgres,=r/postgres,usps=arwdRxt/postgres,"group 100=r/usps","group ea_development=r/usps"} (1 row)