X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id D7D889DC88D for ; Wed, 1 Mar 2006 06:07:43 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 43908-10 for ; Wed, 1 Mar 2006 06:07:45 -0400 (AST) Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id EB1C29DC88B for ; Wed, 1 Mar 2006 06:07:41 -0400 (AST) Received: from sydney.mailnetwork.co.uk (server88-208-192-113.live-servers.net [88.208.192.113]) by svr4.postgresql.org (Postfix) with ESMTP id AD3B75AF83F for ; Wed, 1 Mar 2006 10:07:44 +0000 (GMT) Received: from [213.146.143.243] (port=57594 helo=[192.168.2.128]) by sydney.mailnetwork.co.uk with esmtpa (Exim 4.60) (envelope-from ) id 1FEOFC-0002q8-NB; Wed, 01 Mar 2006 10:07:43 +0000 Message-ID: <4405726D.9080407@andycc.net> Date: Wed, 01 Mar 2006 10:07:41 +0000 From: Andy Shellam Reply-To: andy@andycc.net Organization: www.mailnetwork.co.uk User-Agent: Thunderbird 1.5 (Windows/20051201) MIME-Version: 1.0 To: itlali.guerrero@inegi.gob.mx Cc: pgsql-admin@postgresql.org Subject: [Fwd: Restricting the access to a database] Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.485 required=5 tests=[AWL=0.485] X-Spam-Score: 0.485 X-Spam-Level: X-Archive-Number: 200603/3 X-Sequence-Number: 20760 In your pg_hba.conf file, you could only allow users to access their own databases, so if they try and login with another database, it fails. e..g host db1 user1 0.0.0.0/0 md5 host db1 user2 0.0.0.0/0 md5 host db1 user3 0.0.0.0/0 md5 host example1 user2 0.0.0.0/0 md5 host all postgres 0.0.0.0/0 md5 Dont know whether this would stop them from seeing the database entirely, but on a custom schema, would revoking USG grant stop them from browsing that schema? Andy -------- Original Message -------- Subject: [ADMIN] Restricting the access to a database Date: Thu, 23 Feb 2006 15:07:05 -0600 From: KyLiE To: pgsql-admin@postgresql.org Hi all, im new in this and my question can sound stupid, here is the thing, i have a server wich have 3 databases, each one with different users(user1, user2 and user3) user1 have : db1, db2 and db3 user2 have : example1 and user3 have : pgadmin Im trying this : I want that user1 have access only to his databases, and so on,i mean user1 most not see : example1, pgadmin. With the schema i resrict this but only on the tables of adatabase, but if you change search_path and add the user1's schema then you can see their tables. Does anyone has done it, or know how to do this?? thanks ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend !DSPAM:14,440507aa49411946914759!