Dear All
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).
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!!!
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.
Many thanks
Hilary
DMR Limited (UK registration 01134804)
A DMR Information and Technology Group company
(www.dmr.co.uk)
Direct tel 01689 889950 Fax 01689 860330
DMR is a UK registered trade mark of DMR Limited
**********************************************************