<html>
Dear All<br><br>
We are running pg v 7.4.1 and importantly the database has been converted
from earlier versions of pg (6.5 I seem to recall).<br><br>
I have an existing table suppliers and I have created a new user
'hilary'<br><br>
REVOKE ALL on TABLE suppliers FROM hilary;<br><br>
now login as hilary<br>
SELECT * from suppliers;<br>
and I get all the records!!!<br><br>
If I create a **new** table though and then do the above, the permissions
work I get a polite message telling me "no go". This
sounds to me like a problem with earlier compatibility. Is there a
way I can overcome this. A simple dump/restore does not solve the
problem.<br><br>
Many thanks<br>
Hilary<br>
<x-sigsep><p></x-sigsep>
Hilary Forbes<br>
DMR Limited (UK registration 01134804) <br>
A DMR Information and Technology Group company
(<a href="http://www.dmr.co.uk/" eudora="autourl"><font color="#0000FF"><u>www.dmr.co.uk</a></u></font>)
<br>
Direct tel 01689 889950 Fax 01689 860330 <br>
DMR is a UK registered trade mark of DMR Limited<br>
**********************************************************</html>