Re: [SPAM] Re: Permissions not working

Peter Eisentraut wrote:

>Pallav Kalva wrote:
>  
>
>>    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.
>>    
>>
>
>What about all those groups that have privileges?  Please post the 
>output of \z when you try a revoke so we can verify what's going on.
>

here is the output. This is the same output, this output doesnt change 
at all.

usps=> \z citystate_alias
                                                      Access privileges 
for database "usps"
 Schema |      Table      
|                                                   Access privileges
--------+-----------------+-----------------------------------------------------------------------------------------------------------------------
 public | citystate_alias | 
{postgres=a*r*w*d*R*x*t*/postgres,=r/postgres,usps=arwdRxt/postgres,"group 
100=r/usps","group ea_development=r/usps"}
(1 row)