Re: [SPAM] Re: Permissions not working

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