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 B16A5D1C93B for ; Mon, 17 May 2004 17:46:19 -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 81672-02 for ; Mon, 17 May 2004 17:46:01 -0300 (ADT) Received: from megazone.bigpanda.com (megazone.bigpanda.com [64.147.171.210]) by svr1.postgresql.org (Postfix) with ESMTP id BC6ACD1CA6E for ; Mon, 17 May 2004 17:45:59 -0300 (ADT) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id 11D3D3525B; Mon, 17 May 2004 13:45:10 -0700 (PDT) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id 1048235251; Mon, 17 May 2004 13:45:10 -0700 (PDT) Date: Mon, 17 May 2004 13:45:10 -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: <71E37EF6B7DCC1499CEA0316A2568328010579AC@loki.wc.globexplorer.net> Message-ID: <20040517134309.M29238@megazone.bigpanda.com> References: <71E37EF6B7DCC1499CEA0316A2568328010579AC@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/167 X-Sequence-Number: 13483 On Mon, 17 May 2004, Gregory S. Williamson wrote: > Stephan, > > Thanks for the info, but alas, no success. > > I have: > List of database users > User name | User ID | Attributes > -----------+---------+---------------------------- > testuser | 100 | > postgres | 1 | superuser, create database > > > And as postgres I ran: > REVOKE ALL ON SCHEMA public FROM testuser; I forgot to mention something which led to the confusion. testuser doesn't probably have permissions on the public schema, but public (all users) does. You probably need to revoke it from PUBLIC and grant it to the users who should have creation rights to public.