X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id B521B3CC973 for ; Sat, 18 Dec 2004 17:54:56 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 31529-07 for ; Sat, 18 Dec 2004 17:54:49 +0000 (GMT) Received: from nabocudonosor.cmn-consulting.com (unknown [66.199.235.26]) by svr1.postgresql.org (Postfix) with ESMTP id 406083A3BBB for ; Sat, 18 Dec 2004 17:54:49 +0000 (GMT) Received: (qmail 32500 invoked by uid 508); 18 Dec 2004 12:56:20 -0500 Received: from static-ip-cr20011811939.cable.net.co (HELO ?192.168.0.50?) (200.118.119.39) by nabocudonosor.cmn-consulting.com with SMTP; 18 Dec 2004 12:56:20 -0500 Subject: Revoke on all database From: Henry Molina To: pgsql-sql@postgresql.org Content-Type: text/plain Organization: CMN Consulting Message-Id: <1103392473.2940.38.camel@prometeo> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Sat, 18 Dec 2004 12:54:33 -0500 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.026 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200412/134 X-Sequence-Number: 19754 Hi all, Can I revoke "delete" on all database, something like this: REVOKE DELETE ON DATABASE mydb FROM PUBLIC; thanks! -- Henry Molina R&D CMN Consulting