From: Rajesh Kumar Mallah. <mallah@trade-india.com>
To: dima <_pppp@mail.ru>
Cc: pgsql-sql@postgresql.org
Subject: Re: Preventing DELETEs
Date: Fri, 27 Sep 2002 00:47:42 +0530
Message-ID: <200209270047.42639.mallah@trade-india.com> (raw)
In-Reply-To: <3D93594A.6010407@mail.ru>
References: <200209270030.16040.mallah@trade-india.com>
<3D93594A.6010407@mail.ru>
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.
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
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=> \l
List of databases
Name | Owner
-----------------+----------
template0 | postgres
template1 | postgres
tradein_clients | tradein (this is me)
(3 rows)
tradein_clients=>
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
--
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.
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: mallah@trade-india.com, _pppp@mail.ru
Subject: Re: Preventing DELETEs
In-Reply-To: <200209270047.42639.mallah@trade-india.com>
* 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