Re: [SPAM] Re: Permissions not working - Mailing list pgsql-sql

>>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=>