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 BA940D1EF3F for ; Mon, 3 May 2004 12:01:33 -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 00627-03 for ; Mon, 3 May 2004 12:01:16 -0300 (ADT) Received: from mail.deg.cc (mail.deg.cc [198.70.16.196]) by svr1.postgresql.org (Postfix) with ESMTP id B2844D1EF1A for ; Mon, 3 May 2004 12:01:11 -0300 (ADT) Received: from deg.cc (barney.deg.cc [198.70.16.205]) by mail.deg.cc (Postfix) with ESMTP id 12BA655F84; Mon, 3 May 2004 11:01:13 -0400 (EDT) Message-ID: <40965FD9.3020606@deg.cc> Date: Mon, 03 May 2004 11:06: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: Tom Lane Cc: Peter Eisentraut , "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> <40964A0D.5070105@deg.cc> <13033.1083594203@sss.pgh.pa.us> In-Reply-To: <13033.1083594203@sss.pgh.pa.us> 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/13 X-Sequence-Number: 17727 >>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 > > > Hi Tom, 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. -------------------------------------------------------------------------------------------------------- [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 privileges on citystate_alias from public,test; REVOKE usps=# \q [pkalva@timmy pkalva]$ psql usps usps 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 privileges on citystate_alias from public,test; REVOKE usps=> revoke select on citystate_alias 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 | aliasstre etsuffix | aliasstreetpostdir | streetpredir | streetname | streetsuffix | stree tpostdir | typecode | century | year | month | day | lownumber | highnumber | od doreven | 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=>