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 5F61CD1EF61 for ; Mon, 3 May 2004 10:28:46 -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 57608-06 for ; Mon, 3 May 2004 10:28:25 -0300 (ADT) Received: from mail.deg.cc (mail.deg.cc [198.70.16.196]) by svr1.postgresql.org (Postfix) with ESMTP id 1F345D1EF15 for ; Mon, 3 May 2004 10:28:21 -0300 (ADT) Received: from deg.cc (barney.deg.cc [198.70.16.205]) by mail.deg.cc (Postfix) with ESMTP id A846A55F86; Mon, 3 May 2004 09:28:17 -0400 (EDT) Message-ID: <40964A0D.5070105@deg.cc> Date: Mon, 03 May 2004 09:33:01 -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: <26201.1083341979@sss.pgh.pa.us> <40929453.10501@deg.cc> <200405012313.45607.peter_e@gmx.net> In-Reply-To: <200405012313.45607.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/10 X-Sequence-Number: 17724 Peter Eisentraut wrote: >Pallav Kalva wrote: > > >>Also here is the privileges information from information_schema >>tables. Is there a way to REVOKE these >>privileges ? >> >> > >You need to log in as the user that has granted the privilege you want >to revoke. In this case, log in as postgres and do REVOKE ALL FROM >PUBLIC;. > > > I did the same, still doesnt work . Here is the sequence of what I did . --------------------------------------------------------------------------------------- [pkalva@timmy pkalva]$ psql usps postgres Welcome to psql 7.4.2, the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h for help with SQL commands \? for help on internal slash commands \g or terminate with semicolon to execute query \q to quit usps=# revoke all on database usps from public,test; REVOKE usps=# \q [pkalva@timmy pkalva]$ psql usps test Welcome to psql 7.4.2, the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h for help with SQL commands \? for help on internal slash commands \g or terminate with semicolon to execute query \q to quit usps=> select * from citystate_alias limit 1; detailcode | zipcode | aliasstreetpredir | aliasstreetname | aliasstreetsuffix | aliasstreetpostdir | streetpredir | streetname | streetsuffix | streetpostdir | typecode | century | year | month | day | lownumber | highnumber | oddoreven | filler | entrydate ------------+---------+-------------------+--------------------------+-------------------+--------------------+--------------+------------+--------------+---------------+----------+---------+------+-------+-----+-----------+------------+-----------+--------+------------------------------- A | 00501 | | INTERNAL REVENUE SERVICE | | | | WAVERLY | AVE | | O | 19 | 94 | 05 | 01 | | | | | 2004-04-22 14:51:45.497651-04 (1 row) usps=>