X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 2F68DD1C9E1 for ; Mon, 17 May 2004 12:04:02 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 19827-08 for ; Mon, 17 May 2004 12:03:42 -0300 (ADT) Received: from megazone.bigpanda.com (megazone.bigpanda.com [64.147.171.210]) by svr1.postgresql.org (Postfix) with ESMTP id D7CB3D1C4E2 for ; Mon, 17 May 2004 12:03:41 -0300 (ADT) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id 255E2359DF; Mon, 17 May 2004 08:03:41 -0700 (PDT) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id 23F7C3596B; Mon, 17 May 2004 08:03:41 -0700 (PDT) Date: Mon, 17 May 2004 08:03:41 -0700 (PDT) From: Stephan Szabo To: "Gregory S. Williamson" Cc: pgsql-admin@postgresql.org Subject: Re: Keep a user from creating tables ? In-Reply-To: <71E37EF6B7DCC1499CEA0316A2568328010579A6@loki.wc.globexplorer.net> Message-ID: <20040517080153.P21709@megazone.bigpanda.com> References: <71E37EF6B7DCC1499CEA0316A2568328010579A6@loki.wc.globexplorer.net> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200405/158 X-Sequence-Number: 13474 On Sun, 16 May 2004, Gregory S. Williamson wrote: > In postgres 7.4, is there any way to stop a user from creating tables in a given database ? Make the user not have rights to create objects in any schemas. Most likely you'd only need to change the public schema, but if you've granted create rights for other schemas you'll need to revoke those as well.