Re: Permissions not working

Tom Lane wrote:

>Pallav Kalva <pkalva@deg.cc> writes:
>  
>
>>I have a database for ex: 'ups' and it was owned previously by 
>>'postgres(superuser)' but now i have changed the ownership to new user 
>>'ups' all the tables are owned by these user 'ups'.
>>    
>>
>
>That isn't a supported operation.  How did you do it exactly?  I suspect
>that you got it wrong somehow ...
>  Sorry, I wasnt clear on this. First I created a database called 'ups' 
and made user 'ups' as its owner. Then  I dumped the database from backup, the dumped database backup was 
owned by 'postgres ' user but all the  tables in this database are owned by 'ups' user.


>
>  
>
>>I dont want  user 'test' to access any tables from the 'ups' 
>>database, i tried revoking permissions it still doesnt work.
>>    
>>
>
>What did you revoke?  What does psql's "\z" command show for the problem
>tables?
>
>            regards, tom lane
>
>---------------------------(end of broadcast)---------------------------
>TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
>  
>
Here is the output from the \z . I tried to revoke all the privileges 
from the PUBLIC and user 'test'.

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)