Pallav Kalva <pkalva(at)deg(dot)cc> writes:
> I did the same, still doesnt work . Here is the sequence of what I did .
> usps=# revoke all on database usps from public,test;
You seem to think that that translates to revoking all privileges to
objects within the database. It doesn't. It only revokes privileges
directly associated with the database object, which are the rights to
create new schemas and temp tables within the database.
regards, tom lane