Re: Permissions not working

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

> 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