Pallav Kalva <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly