Re: Help with privilages please

Hilary Forbes  writes:
> I have an existing table suppliers and I have created a new user
> 'hilary'


> REVOKE ALL on TABLE suppliers FROM hilary;


> now login as hilary

> SELECT * from suppliers;

> and I get all the records!!!



Most likely there's been a grant of (at least) select privilege to PUBLIC.
You'll need to revoke that if you don't want every user to have that
privilege implicitly.
		regards, tom lane