X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 6F1F99FB1C9 for ; Sun, 3 Sep 2006 15:47:24 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 54297-06 for ; Sun, 3 Sep 2006 15:47:15 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from wolff.to (wolff.to [66.93.197.194]) by postgresql.org (Postfix) with SMTP id D0A799FB1C8 for ; Sun, 3 Sep 2006 15:47:15 -0300 (ADT) Received: (qmail 5734 invoked by uid 500); 3 Sep 2006 18:55:34 -0000 Date: Sun, 3 Sep 2006 13:55:34 -0500 From: Bruno Wolff III To: "F. Kleinpaul" Cc: pgsql-admin@postgresql.org Subject: Re: REVOKE DROP tables Message-ID: <20060903185534.GA4707@wolff.to> Mail-Followup-To: Bruno Wolff III , "F. Kleinpaul" , pgsql-admin@postgresql.org References: <60ee419c0609020433o718a85f4p5efb2bfb99b33dc6@mail.gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <60ee419c0609020433o718a85f4p5efb2bfb99b33dc6@mail.gmail.com> User-Agent: Mutt/1.4.2.1i X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.034 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200609/19 X-Sequence-Number: 22933 On Sat, Sep 02, 2006 at 08:33:52 -0300, "F. Kleinpaul" 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.