Content-Type: text/plain;
  charset="iso-8859-1"
From: "Rajesh Kumar Mallah." <mallah@trade-india.com>
Organization: Infocom Network Limited.
To: dima <_pppp@mail.ru>
Subject: Re: Preventing DELETEs
Date: Fri, 27 Sep 2002 00:47:42 +0530
User-Agent: KMail/1.4.1
Cc: pgsql-sql@postgresql.org
References: <200209270030.16040.mallah@trade-india.com>
	<3D93594A.6010407@mail.ru>
In-Reply-To: <3D93594A.6010407@mail.ru>
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable
Message-Id: <200209270047.42639.mallah@trade-india.com>


Hi Dima,

I currently have only one  user in the system
its me and superuser postgres.

every thing belongs to me currently.
and the programs connect as me.=20


if make transfer the database ownership to postgres
will all the tables also get transfered to him?

it that case all programs will stop working.

can i transefer database ownership to postgres and=20
allow myself ALL the PREVILEGES and selectively
REVOKE the DELETE permission from myself on the concerned
table?

If that is possible could you kindly tell me the commands

Current state is:

tradein_clients=3D> \l
     List of databases
      Name       |  Owner=20=20=20
-----------------+----------
 template0       | postgres
 template1       | postgres
 tradein_clients | tradein (this is me)
(3 rows)
tradein_clients=3D>=20


regds
Mallah.


On Friday 27 September 2002 00:30, dima wrote:
> > I have a created a database and a table in it,
> >
> > I want to prevent "DELETES" on the table in this
> > database by everyone except superuser postgres.
> > even by me (the creator of this database and table)
>
> make superuser the database owner & grant the rights needed to the users

--=20
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)

Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace.