Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 47BD29FB5BA for ; Wed, 21 Mar 2007 15:33:35 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 27694-02-2 for ; Wed, 21 Mar 2007 15:33:16 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from bay0-omc3-s14.bay0.hotmail.com (bay0-omc3-s14.bay0.hotmail.com [65.54.246.214]) by postgresql.org (Postfix) with ESMTP id 27E2B9FB55B for ; Wed, 21 Mar 2007 15:33:17 -0300 (ADT) Received: from hotmail.com ([65.55.136.107]) by bay0-omc3-s14.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.2668); Wed, 21 Mar 2007 11:33:16 -0700 Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Wed, 21 Mar 2007 11:33:16 -0700 Message-ID: Received: from 65.55.136.123 by by131fd.bay131.hotmail.msn.com with HTTP; Wed, 21 Mar 2007 18:33:13 GMT X-Originating-IP: [67.116.31.14] X-Originating-Email: [skarthi98@hotmail.com] X-Sender: skarthi98@hotmail.com In-Reply-To: <1174499213.24543.356.camel@soundwave.pgh.priv.collaborativefusion.com> From: "Karthikeyan Sundaram" To: bseklecki@collaborativefusion.com, morten@nidelven-it.no Cc: pgsql-admin@postgresql.org Subject: Re: Read-only access to a database Date: Wed, 21 Mar 2007 11:33:13 -0700 Mime-Version: 1.0 Content-Type: text/plain; format=flowed X-OriginalArrivalTime: 21 Mar 2007 18:33:16.0269 (UTC) FILETIME=[640009D0:01C76BE7] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200703/151 X-Sequence-Number: 24975 when you create a role, you can specify, nocreate option. Then when you grant the tables to this user give only select privilege. Regards skarthi >From: "Brian A. Seklecki" >To: "Morten W. Petersen" >CC: pgsql-admin@postgresql.org >Subject: Re: [ADMIN] Read-only access to a database >Date: Wed, 21 Mar 2007 13:46:53 -0400 > >Wouldn't you just set read-only ACLs for that role on all of the objects >in the database in question? > >~BAS > >On Wed, 2007-03-21 at 17:42 +0100, Morten W. Petersen wrote: > > Hi, > > > > I'd like to create a user that has read-only access to > > a database. > > > > I've read the docs and fumbled around a bit (even > > tried to use phppgadmin) - but nothing works. > > > > "CREATE USER username" is about as far as I've > > gotten. Which other commands would I have to > > use to enable read-only access to a database? > > > > Thanks, > > > > Morten > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 4: Have you searched our list archives? > > > > http://archives.postgresql.org >-- >Brian A. Seklecki >Collaborative Fusion, Inc. > > > > >IMPORTANT: This message contains confidential information and is intended >only for the individual named. If the reader of this message is not an >intended recipient (or the individual responsible for the delivery of this >message to an intended recipient), please be advised that any re-use, >dissemination, distribution or copying of this message is prohibited. >Please notify the sender immediately by e-mail if you have received this >e-mail by mistake and delete this e-mail from your system. > > > >---------------------------(end of broadcast)--------------------------- >TIP 1: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly _________________________________________________________________ It’s tax season, make sure to follow these few simple tips http://articles.moneycentral.msn.com/Taxes/PreparationTips/PreparationTips.aspx?icid=HMMartagline