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 9B6B0D8BE2 for ; Mon, 26 Sep 2005 07:09:34 -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 30889-05 for ; Mon, 26 Sep 2005 10:09:30 +0000 (GMT) Received: from web53507.mail.yahoo.com (web53507.mail.yahoo.com [206.190.37.68]) by svr1.postgresql.org (Postfix) with SMTP id BC41ED8BC7 for ; Mon, 26 Sep 2005 07:09:30 -0300 (ADT) Received: (qmail 95052 invoked by uid 60001); 26 Sep 2005 10:09:33 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=RtM2yn+KxqSIk3YSiVPQZrDo3lA/GcCWa9l+1pNPLi6uvNRTWLwV5A+VSorgFuF4bXPiaPoIGA0lGV6KAZaJOf/y/Sz+qsUAdBaSgved8lBpxCdibE/xPSmUvg0pUC1Z+F0nXy9QZBAOMwDTjiMFkFgxb09e7ZPGUoIL4mHWFbE= ; Message-ID: <20050926100933.95050.qmail@web53507.mail.yahoo.com> Received: from [196.38.142.117] by web53507.mail.yahoo.com via HTTP; Mon, 26 Sep 2005 03:09:32 PDT Date: Mon, 26 Sep 2005 03:09:32 -0700 (PDT) From: Allan Kamau Subject: Preventing database access (including valid users in other databases) To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.312 required=5 tests=[AWL=-0.062, DNS_FROM_RFC_ABUSE=0.374] X-Spam-Level: X-Archive-Number: 200509/288 X-Sequence-Number: 19025 I would like to prevent users including users who may be valid in other databases from accessing a particular database, I have excluded database – username associations of their usernames with the database in the hba.conf file, but I observed that they can still connect to the database, query metadata (by use of \d) but cannot perform queries. Is there a way to fully prevent database connect and query of metadata? 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 – 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 and should I explicitly change ownership of the objects. Allan. __________________________________ Yahoo! Mail - PC Magazine Editors' Choice 2005 http://mail.yahoo.com