Help with privilages please
От | Hilary Forbes |
---|---|
Тема | Help with privilages please |
Дата | |
Msg-id | 5.1.0.14.0.20060720145514.03833140@mailserver.dmr.co.uk обсуждение исходный текст |
Ответы |
Re: Help with privilages please
Re: Help with privilages please Re: Help with privilages please |
Список | pgsql-sql |
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 /> **********************************************************
В списке pgsql-sql по дате отправления: