REVOKE ALL on TABLE suppliers FROM hilary;
now login as hilary
SELECT * from suppliers;
and I get all the records!!!
If I create a **new** table though and then do the above, the permissionswork I get a polite
message telling me "no go". Thissounds to me like a problem with earlier compatibility. Is there
away I can overcome this. A simple dump/restore does not solve theproblem.
You might also have to revoke all from public:
Regards,
Richard Broersma Jr.
