Re: i have a problem of privilages - Mailing list pgsql-sql

From Andreas Kretschmer
Subject Re: i have a problem of privilages
Date
Msg-id 20060704153015.GA9838@KanotixBox
Whole thread Raw
In response to Re: i have a problem of privilages  ("MJ Santhosh" <mjsanthosh@gmail.com>)
List pgsql-sql
MJ Santhosh <mjsanthosh@gmail.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_@_i_n_f_i_c_s_._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°


pgsql-sql by date:

Previous
From: Richard Broersma Jr
Date:
Subject: Re: i have a problem of privilages
Next
From: "Aaron Bono"
Date:
Subject: Re: SQL (Venn diagram type of logic)