From: | Andreas Kretschmer <akretschmer(at)spamfence(dot)net> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: i have a problem of privilages |
Date: | 2006-07-04 15:30:15 |
Message-ID: | 20060704153015.GA9838@KanotixBox |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
MJ Santhosh <mjsanthosh(at)gmail(dot)com> 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.. <_p_e_n_c_h_a_l_a_i_a_h_p_(at)_i_n_f_i_c_s_(dot)_c_o_m> 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°
From | Date | Subject | |
---|---|---|---|
Next Message | Aaron Bono | 2006-07-04 16:55:06 | Re: SQL (Venn diagram type of logic) |
Previous Message | Richard Broersma Jr | 2006-07-04 14:51:52 | Re: i have a problem of privilages |