Re: REVOKE DROP tables

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: "F(dot) Kleinpaul" <fkleinpaul(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: REVOKE DROP tables
Date: 2006-09-03 18:55:34
Message-ID: 20060903185534.GA4707@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Sat, Sep 02, 2006 at 08:33:52 -0300,
"F. Kleinpaul" <fkleinpaul(at)gmail(dot)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.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Aaron Bono 2006-09-03 23:25:24 Re: archive logs recovery
Previous Message Tom Lane 2006-09-02 14:23:02 Re: REVOKE DROP tables