From: Andreas Kretschmer <akretschmer@spamfence.net>
To: pgsql-sql@postgresql.org
Subject: Re: i have a problem of privilages
Date: Tue, 4 Jul 2006 17:30:15 +0200
Message-ID: <20060704153015.GA9838@KanotixBox> (raw)
In-Reply-To: <224a3e7e0607040531t33821d87t7d21920637417bf5@mail.gmail.com>
References: <A70AE049E81A6A40879D5DC0AC8C38C906979FCA@venus.infics.com>
<224a3e7e0607040531t33821d87t7d21920637417bf5@mail.gmail.com>
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°
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: akretschmer@spamfence.net
Subject: Re: i have a problem of privilages
In-Reply-To: <20060704153015.GA9838@KanotixBox>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox