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