Re: REVOKE DROP tables - Mailing list pgsql-admin

From Bruno Wolff III
Subject Re: REVOKE DROP tables
Date
Msg-id 20060903185534.GA4707@wolff.to
Whole thread Raw
In response to REVOKE DROP tables  ("F. Kleinpaul" <fkleinpaul@gmail.com>)
List pgsql-admin
On Sat, Sep 02, 2006 at 08:33:52 -0300,
  "F. Kleinpaul" <fkleinpaul@gmail.com> wrote:
> How can I REVOKE users right to DROP tables?

The owner of a table can always drop it. So you would need to change
the owner of the table using ALTER TABLE table_name OWNER TO new_owner.

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: REVOKE DROP tables
Next
From: "Aaron Bono"
Date:
Subject: Re: archive logs recovery