X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id ED42BD9935 for ; Tue, 27 Sep 2005 11:57:15 -0300 (ADT) 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 31585-05 for ; Tue, 27 Sep 2005 14:57:06 +0000 (GMT) Received: from bramble.mmrd.com (bramble.mmrd.com [65.217.53.66]) by svr1.postgresql.org (Postfix) with ESMTP id C3A25D9921 for ; Tue, 27 Sep 2005 11:57:07 -0300 (ADT) Received: from thorn.mmrd.com (thorn.mmrd.com [172.25.10.100]) by bramble.mmrd.com (8.12.8/8.12.8) with ESMTP id j8RFHZoJ003810; Tue, 27 Sep 2005 11:17:35 -0400 Received: from gnvex001.mmrd.com (gnvex001.mmrd.com [10.225.10.110]) by thorn.mmrd.com (8.11.6/8.11.6) with ESMTP id j8REv4d07531; Tue, 27 Sep 2005 10:57:04 -0400 Received: from camel.mmrd.com ([172.25.5.213]) by gnvex001.mmrd.com with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2657.72) id TWC04F3B; Tue, 27 Sep 2005 10:57:01 -0400 Subject: Re: Preventing database access (including valid users in From: Robert Treat To: Allan Kamau Cc: pgsql-admin@postgresql.org In-Reply-To: <20050926100933.95050.qmail@web53507.mail.yahoo.com> References: <20050926100933.95050.qmail@web53507.mail.yahoo.com> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Mailer: Ximian Evolution 1.0.8 Date: 27 Sep 2005 10:57:03 -0400 Message-Id: <1127833024.19727.222.camel@camel> Mime-Version: 1.0 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.029 required=5 tests=[AWL=0.029] X-Spam-Level: X-Archive-Number: 200509/297 X-Sequence-Number: 19034 On Mon, 2005-09-26 at 06:09, Allan Kamau wrote: > Interesting scenario, I have a user who owns database > objects (tables, sequences) in a database, now I have > decided not to allow the user by connect to the > database by excluding the user's username from the > database =96 username association in the hba.conf, I > restarted the server. However the user can still > connect to the database, and the user can query the > objects they own but cannot query objects they do not > own in that database. Is this the expected behaviour Personally I think you've misconfigured your pg_hba.conf. If you'd like to send it along with your db version you might be able to get a more definitive answer. > and should I explicitly change ownership of the > objects. >=20 Well, it doesn't make much sense to me to have a bunch of objects in a database owned by someone who will never be allowed to connect to that database.=20 Robert Treat --=20 Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL