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 7DEE19DC819 for ; Thu, 23 Feb 2006 17:09:06 -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 70195-08 for ; Thu, 23 Feb 2006 17:09:07 -0400 (AST) Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 899159DC86F for ; Thu, 23 Feb 2006 17:09:04 -0400 (AST) Received: from CORREOAGS03.inegi.gob.mx (unknown [200.23.9.137]) by svr4.postgresql.org (Postfix) with ESMTP id 97FE25AF18A for ; Thu, 23 Feb 2006 21:09:06 +0000 (GMT) Received: from [10.22.6.71] ([10.22.6.71]) by CORREOAGS03.inegi.gob.mx with Microsoft SMTPSVC(6.0.3790.1830); Thu, 23 Feb 2006 15:07:08 -0600 Message-ID: <43FE23F9.4000908@inegi.gob.mx> Date: Thu, 23 Feb 2006 15:07:05 -0600 From: KyLiE User-Agent: Mozilla Thunderbird 1.0.7 (X11/20051013) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Restricting the access to a database Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 23 Feb 2006 21:07:08.0971 (UTC) FILETIME=[1B9A4FB0:01C638BD] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200602/333 X-Sequence-Number: 20754 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