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 6A619D9A0D for ; Wed, 28 Sep 2005 07:24:53 -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 67168-04 for ; Wed, 28 Sep 2005 10:24:46 +0000 (GMT) Received: from web51607.mail.yahoo.com (web51607.mail.yahoo.com [206.190.38.212]) by svr1.postgresql.org (Postfix) with SMTP id 0790CD9A64 for ; Wed, 28 Sep 2005 07:24:46 -0300 (ADT) Received: (qmail 52914 invoked by uid 60001); 28 Sep 2005 10:24:45 -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=dsXIPaS7t9qhDU+3P2u2RVOV//Gp1YGWh8ECPzv4QB2lBaZ9LtlFx3ozNJ+QEA38dIYOrwwi2o94xtSc2gLlvLfzDej+IhPViLKaW9ovND8Qa6lWkWo4MyCKZ8GwgfstWQZVeKn2/cKoV2lby+d4ehrCvPrGUMbaQZrFUtcntHg= ; Message-ID: <20050928102445.52912.qmail@web51607.mail.yahoo.com> Received: from [59.184.3.29] by web51607.mail.yahoo.com via HTTP; Wed, 28 Sep 2005 03:24:45 PDT Date: Wed, 28 Sep 2005 03:24:45 -0700 (PDT) From: bramhe manoj Subject: database access queries 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.374 required=5 tests=[DNS_FROM_RFC_ABUSE=0.374] X-Spam-Level: X-Archive-Number: 200509/300 X-Sequence-Number: 19037 hi , we are working as linux administrators in enng college in mumbai(india). we have created databases in postgresql for all staffs & students & granted them with permissions & password query : how to restrict database user from accessing other users databases? here we are getting problem that any user can access database of other users pls tell us how we can do in postgresql bye prof bramhe prof pandagre __________________________________ Yahoo! Mail - PC Magazine Editors' Choice 2005 http://mail.yahoo.com