X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 3F1DE9FA4A8 for ; Wed, 5 Jul 2006 14:46:25 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 83152-04-3 for ; Wed, 5 Jul 2006 14:46:13 -0300 (ADT) X-Greylist: delayed 00:25:31.461564 by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 95BBD9FB1CF for ; Wed, 5 Jul 2006 14:46:09 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from CORREOAGS03.inegi.gob.mx (unknown [200.23.9.67]) by svr4.postgresql.org (Postfix) with ESMTP id CCE495AF071 for ; Wed, 5 Jul 2006 17:20:36 +0000 (GMT) Received: from [10.22.6.71] ([10.22.6.71]) by CORREOAGS03.inegi.gob.mx with Microsoft SMTPSVC(6.0.3790.1830); Wed, 5 Jul 2006 12:18:54 -0500 Message-ID: <44ABF47E.7000605@inegi.gob.mx> Date: Wed, 05 Jul 2006 12:18:54 -0500 From: KyLiE User-Agent: Thunderbird 1.5.0.4 (X11/20060516) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: %psql help Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 05 Jul 2006 17:18:54.0347 (UTC) FILETIME=[177F85B0:01C6A057] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/25 X-Sequence-Number: 22271 Hi all, I'm quiet new in this stuff, I have N psql users and N databases, each user has a database and can connect to it using his psql account, however I don't want to allow that some user access to another database that does not belong to him. I've modify my pg_hba.conf file, and allow the access to the databases acording to his owner, but once the user has connected to the DB it can change the connection to another using this command : \c db1 user2, so my question is, can I revoke commands?? or can I configure it per user?? or something?? Regards.