X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 6A3DE32ADA4 for ; Thu, 21 Oct 2004 06:45:10 +0100 (BST) 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 71242-02 for ; Thu, 21 Oct 2004 05:45:06 +0000 (GMT) Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by svr1.postgresql.org (Postfix) with ESMTP id E378332AE17 for ; Thu, 21 Oct 2004 06:44:55 +0100 (BST) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr4.postgresql.org (Postfix) with ESMTP id A592C5AF50F for ; Thu, 21 Oct 2004 03:36:34 +0000 (GMT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id i9L3Y4UU010988; Wed, 20 Oct 2004 23:34:04 -0400 (EDT) To: Joe Maldonado Cc: pgsql-admin@postgresql.org Subject: Re: REVOKE not working... In-reply-to: <41767366.7040305@webehosting.biz> References: <41767366.7040305@webehosting.biz> Comments: In-reply-to Joe Maldonado message dated "Wed, 20 Oct 2004 10:17:10 -0400" Date: Wed, 20 Oct 2004 23:34:04 -0400 Message-ID: <10987.1098329644@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.8 tagged_above=0.0 required=5.0 tests=BIZ_TLD X-Spam-Level: X-Archive-Number: 200410/269 X-Sequence-Number: 15262 Joe Maldonado writes: > But when I issue a REVOKE CREATE ON DATABASE mydb FROM myuser; > The user can still create tables... CREATE privilege on a database concerns the right to create schemas within the database. Whether you can create tables within a schema is a different privilege on a different object. In particular, the default setup is that everyone can create tables within the "public" schema in each database. Revoke CREATE on that (from PUBLIC, not just myuser) and you'll start to get somewhere. regards, tom lane