Re: Preventing DELETEs

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       | postgrestemplate1       | postgrestradein_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.