Dear All<br /><br /> We are running pg v 7.4.1 and importantly the database has been converted from earlier versions
ofpg (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 />
andI get all the records!!!<br /><br /> If I create a **new** table though and then do the above, the permissions work
Iget a polite message telling me "no go". This sounds to me like a problem with earlier compatibility. Is there a way
Ican overcome this. A simple dump/restore does not solve the problem.<br /><br /> Many thanks<br /> Hilary<br /><p>
HilaryForbes<br /> DMR Limited (UK registration 01134804) <br /> A DMR Information and Technology Group company (<a
eudora="autourl"href="http://www.dmr.co.uk/"><font color="#0000FF"><u>www.dmr.co.uk</u></font></a>) <br /> Direct tel
01689889950 Fax 01689 860330 <br /> DMR is a UK registered trade mark of DMR Limited<br />
**********************************************************