From msramsey22@yahoo.com Fri May 25 14:49:09 2007 Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 66E899FB901 for ; Fri, 25 May 2007 11:49:09 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 15383-03-3 for ; Fri, 25 May 2007 11:48:57 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from web31801.mail.mud.yahoo.com (web31801.mail.mud.yahoo.com [68.142.207.64]) by postgresql.org (Postfix) with SMTP id A357F9FC157 for ; Fri, 25 May 2007 11:49:03 -0300 (ADT) Received: (qmail 7375 invoked by uid 60001); 25 May 2007 14:49:01 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=2dD+8q5hhv1XSsirP2mYadATnz78i8UUOhO/w5YpZW0MTlkZrkhVwB38UKZ9HS+Rul1WAAuxBN1rIsrIcwTwdl4zKCXUkaUusG0LNrUUeP+t/Vn3k+r9aafA1o+Fb8FHL7CZV8K2Zj4Yqmo+Fmw0vLv/vqpzuY8ZNbBcbO1M/Ys=; X-YMail-OSG: 8PAiSggVM1kJ5wQEjnK7D8Ia04kNhABsjznYANwWSsSsohHR4wZ25CxoDvQrRfOu57RdVMD3.db2g__.FOU3YMxjwxOeVUUXdP28yOx1b2gmLfN7nCzNauT1S2cOpA-- Received: from [170.153.62.251] by web31801.mail.mud.yahoo.com via HTTP; Fri, 25 May 2007 07:49:01 PDT Date: Fri, 25 May 2007 07:49:01 -0700 (PDT) From: Marsha Ramsey Subject: User DB Access - RESTRICTIONS To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1042697748-1180104541=:7345" Content-Transfer-Encoding: 8bit Message-ID: <830906.7345.qm@web31801.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=3.667 tagged_above=0 required=5 tests=BAYES_40=-0.185, DNS_FROM_RFC_ABUSE=0.2, DNS_FROM_RFC_POST=1.708, DNS_FROM_RFC_WHOIS=1.447, HTML_40_50=0.496, HTML_MESSAGE=0.001 X-Spam-Level: *** X-Archive-Number: 200705/284 X-Sequence-Number: 25604 --0-1042697748-1180104541=:7345 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Hello all, How to make a postgres user have access to only one database, and to set that access as read only? Thanks...Marsha --------------------------------- Get the Yahoo! toolbar and be alerted to new email wherever you're surfing. --0-1042697748-1180104541=:7345 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Hello all,

How to make a postgres user have access to only one database, and to set that access as read only?

Thanks...Marsha


Get the Yahoo! toolbar and be alerted to new email wherever you're surfing. --0-1042697748-1180104541=:7345-- From msramsey22@yahoo.com Fri May 25 15:28:51 2007 Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 2EEBB9FB919 for ; Fri, 25 May 2007 12:28:51 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 37324-08 for ; Fri, 25 May 2007 12:28:35 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from web31806.mail.mud.yahoo.com (web31806.mail.mud.yahoo.com [68.142.207.69]) by postgresql.org (Postfix) with SMTP id 529869FC195 for ; Fri, 25 May 2007 12:28:35 -0300 (ADT) Received: (qmail 47990 invoked by uid 60001); 25 May 2007 15:28:34 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=Id0kbHxMoTHyPkuV5GEXeP5rYW1gqDPHmA/YGqcBThRh4W080EhVrrd1sHDSyNmI5qmwz7qQ2cjuzaEMkZaGK/MkStWwnOOWvQ2gImEg6GvB5H1kHbN9lgIcsPaPXsYzejrHgGTCry1yIsKvGk28V8XIQZyqGCZttKIEx7oXjmg=; X-YMail-OSG: POo5PBEVM1k_yvuLL4S1K8kjg8c3GlHzDxhpQMv7dt.9eE0z5gGqmpuTmArZQtQwsVpPE4.mEBILgP_yKOlLo_L1U6JbcrweDN56_VTyJuMQbXLqv2JstwsW5dVu0Q-- Received: from [170.153.62.251] by web31806.mail.mud.yahoo.com via HTTP; Fri, 25 May 2007 08:28:33 PDT Date: Fri, 25 May 2007 08:28:33 -0700 (PDT) From: Marsha Ramsey Subject: User DB Access - RESTRICTIONS To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-2019487672-1180106913=:47846" Content-Transfer-Encoding: 8bit Message-ID: <8240.47846.qm@web31806.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=2.212 tagged_above=0 required=5 tests=AWL=1.455, BAYES_00=-2.599, DNS_FROM_RFC_ABUSE=0.2, DNS_FROM_RFC_POST=1.708, DNS_FROM_RFC_WHOIS=1.447, HTML_MESSAGE=0.001 X-Spam-Level: ** X-Archive-Number: 200705/285 X-Sequence-Number: 25605 --0-2019487672-1180106913=:47846 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Hello all, How to make a postgres user have access to only one database, and to set that access as read only? Thanks...Marsha --------------------------------- Get the Yahoo! toolbar and be alerted to new email wherever you're surfing. --------------------------------- The fish are biting. Get more visitors on your site using Yahoo! Search Marketing. --0-2019487672-1180106913=:47846 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit

Hello all,

How to make a postgres user have access to only one database, and to set that access as read only?

Thanks...Marsha


Get the Yahoo! toolbar and be alerted to new email wherever you're surfing.


The fish are biting.
Get more visitors on your site using Yahoo! Search Marketing. --0-2019487672-1180106913=:47846-- From aroravishal22@hotmail.com Mon May 28 03:53:11 2007 Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id AA8E79FB33B for ; Mon, 28 May 2007 00:53:11 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 60726-02 for ; Mon, 28 May 2007 00:52:59 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from bay0-omc3-s18.bay0.hotmail.com (bay0-omc3-s18.bay0.hotmail.com [65.54.246.218]) by postgresql.org (Postfix) with ESMTP id B620E9FB341 for ; Mon, 28 May 2007 00:53:05 -0300 (ADT) Received: from hotmail.com ([207.46.11.112]) by bay0-omc3-s18.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.2668); Sun, 27 May 2007 20:53:04 -0700 Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Sun, 27 May 2007 20:53:04 -0700 Message-ID: Received: from 207.46.11.123 by by123fd.bay123.hotmail.msn.com with HTTP; Mon, 28 May 2007 03:53:01 GMT X-Originating-IP: [59.160.193.34] X-Originating-Email: [aroravishal22@hotmail.com] X-Sender: aroravishal22@hotmail.com In-Reply-To: <830906.7345.qm@web31801.mail.mud.yahoo.com> From: "Vishal Arora" To: msramsey22@yahoo.com, pgsql-admin@postgresql.org Subject: Re: User DB Access - RESTRICTIONS Date: Mon, 28 May 2007 03:53:01 +0000 Mime-Version: 1.0 Content-Type: text/plain; format=flowed X-OriginalArrivalTime: 28 May 2007 03:53:04.0681 (UTC) FILETIME=[B1EE3990:01C7A0DB] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.056 tagged_above=0 required=5 tests=AWL=-0.667, BAYES_40=-0.185, DNS_FROM_RFC_ABUSE=0.2, DNS_FROM_RFC_POST=1.708, MSGID_FROM_MTA_HEADER=0 X-Spam-Level: * X-Archive-Number: 200705/286 X-Sequence-Number: 25606 >From: Marsha Ramsey >To: pgsql-admin@postgresql.org >Subject: [ADMIN] User DB Access - RESTRICTIONS >Date: Fri, 25 May 2007 07:49:01 -0700 (PDT) > >Hello all, > >How to make a postgres user have access to only one database, Configure it in pg_hba.conf file with database name and user. >and to set that access as read only? Grant Select permission on that DB. > >Thanks...Marsha > > > >--------------------------------- >Get the Yahoo! toolbar and be alerted to new email wherever you're surfing. _________________________________________________________________ Make every IM count. Download Messenger and join the i’m Initiative now. It’s free. http://im.live.com/messenger/im/home/?source=TAGHM_MAY07