MJ Santhosh <[EMAIL PROTECTED]> schrieb: > I am not an expert in postgres, may this work for you. > > REVOKE INSERT,UPDATE,DELETE ON ALL from PUBLIC;
IIRC, you cant REVOKE ... ON ALL, you need a table-name instead ALL. But, you can create a script for all tables: http://people.planetpostgresql.org/greg/index.php?/archives/38-Scripting-with-psql.html > On 7/4/06, PPeenncchhaallaaiiaahh PP.. <[EMAIL PROTECTED]> wrote: Please, no silly HTML, and no silly TOFU (german: Text Oben Fullquote Unten), it means the very silly habit to write the answer above the question. This is hard to read. (sorry for my bad english, i know, it's hard to read too) Andreas -- Really, I'm not out to destroy Microsoft. That will just be a completely unintentional side effect. (Linus Torvalds) "If I was god, I would recompile penguin with --enable-fly." (unknow) Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889° ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
