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 E952532ABB2 for ; Thu, 21 Oct 2004 21:04:14 +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 46984-02 for ; Thu, 21 Oct 2004 20:04:10 +0000 (GMT) Received: from mpls-qmqp-04.inet.qwest.net (mpls-qmqp-04.inet.qwest.net [63.231.195.115]) by svr1.postgresql.org (Postfix) with SMTP id BD58132AA72 for ; Thu, 21 Oct 2004 21:04:09 +0100 (BST) Received: (qmail 97299 invoked by uid 0); 21 Oct 2004 20:04:08 -0000 Received: from mpls-pop-12.inet.qwest.net (63.231.195.12) by mpls-qmqp-04.inet.qwest.net with QMQP; 21 Oct 2004 20:04:08 -0000 Received: from 63-227-127-37.dnvr.qwest.net (HELO ?10.0.0.2?) (63.227.127.37) by mpls-pop-12.inet.qwest.net with SMTP; 21 Oct 2004 20:04:08 -0000 Date: Thu, 21 Oct 2004 14:06:23 -0600 Message-Id: <1098389182.21035.72.camel@localhost.localdomain> From: "Scott Marlowe" To: "Joe Maldonado" Cc: pgsql-admin@postgresql.org Subject: Re: REVOKE not working... In-Reply-To: <4177E894.4060604@webehosting.biz> References: <41767366.7040305@webehosting.biz> <1098287120.21035.47.camel@localhost.localdomain> <4177E894.4060604@webehosting.biz> Content-Type: text/plain Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200410/287 X-Sequence-Number: 15280 On Thu, 2004-10-21 at 10:49, Joe Maldonado wrote: > Scott Marlowe wrote: > > >On Wed, 2004-10-20 at 08:17, Joe Maldonado wrote: > > > > > >>Hello all, > >> I have created users for which I have restricted access to SELECT > >>from a set of tables, this works :) > >> But when I issue a REVOKE CREATE ON DATABASE mydb FROM myuser; > >>The user can still create tables...I've also issued this command for the > >>SCHEMA and still no go. > >> > >>Is this a known problem, if so how can I restrict users from creating > >>objects in my db? > >> > >> > > > >Is myuser a superuser? If so, you can revoke all you want and he'll > >still be able to do anything he wants. Also, I think that if myuser > >owns the current database he can always create tables in it. > > > > > > > > > myuser is not a superuser. is the public schema special in that you > cannot revoke create privileges from users accessing it? Is myuser the creator of the database in question?