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 EE08FD1EED0 for ; Mon, 3 May 2004 11:23:47 -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 80082-07 for ; Mon, 3 May 2004 11:23:31 -0300 (ADT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 26911D1EF04 for ; Mon, 3 May 2004 11:23:27 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i43ENNAW013034; Mon, 3 May 2004 10:23:23 -0400 (EDT) To: Pallav Kalva Cc: Peter Eisentraut , "scott.marlowe" , pgsql-sql@postgresql.org Subject: Re: [SPAM] Re: Permissions not working In-reply-to: <40964A0D.5070105@deg.cc> References: <26201.1083341979@sss.pgh.pa.us> <40929453.10501@deg.cc> <200405012313.45607.peter_e@gmx.net> <40964A0D.5070105@deg.cc> Comments: In-reply-to Pallav Kalva message dated "Mon, 03 May 2004 09:33:01 -0400" Date: Mon, 03 May 2004 10:23:23 -0400 Message-ID: <13033.1083594203@sss.pgh.pa.us> From: Tom Lane 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/12 X-Sequence-Number: 17726 Pallav Kalva writes: > I did the same, still doesnt work . Here is the sequence of what I did . > usps=# revoke all on database usps from public,test; You seem to think that that translates to revoking all privileges to objects within the database. It doesn't. It only revokes privileges directly associated with the database object, which are the rights to create new schemas and temp tables within the database. regards, tom lane