Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id EFC7E6501FB for ; Mon, 8 Dec 2008 13:33:24 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 80146-06 for ; Mon, 8 Dec 2008 13:33:21 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from ey-out-2122.google.com (ey-out-2122.google.com [74.125.78.24]) by mail.postgresql.org (Postfix) with ESMTP id B9A8C6501F3 for ; Mon, 8 Dec 2008 13:33:20 -0400 (AST) Received: by ey-out-2122.google.com with SMTP id 6so482538eyi.61 for ; Mon, 08 Dec 2008 09:33:18 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:from:to :content-type:content-transfer-encoding:mime-version:subject:date :x-mailer; bh=k74UeZTvfxD1hP+bk78TUKE5IzMuuPLnAxVmD47gMik=; b=S5cr/HvoYn04NGLTSbrv8TXynBc9jKJT0qfGGS/JfoW57U9cK+LRGaSquft+03v/Fq xfG/VwyyLGDNczozXnL5Uvjwd5sOmLnzihmGIGInt+BP5wEk7S+Uhal0Hh4x0a6xuncI CTi4AYm70SthVjkkb2ieDICYCwOr1qS2e5TFE= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:from:to:content-type:content-transfer-encoding :mime-version:subject:date:x-mailer; b=bQFnlbXqObg8Mm4iun8fWNRrBlG9Jzlayb0TNMe5901oME+eInfw9VgJ74JqfxWUCJ KBaltPE2mz4sTz/4VsKh+Dx8r7ffHdvL/lQCjpgc2ULdRZeJfdNxNjP7xfmrEo7RILRM aXNqzdtFEu6J6hJIs2M79B0VqK95i+t7PmjAc= Received: by 10.210.73.12 with SMTP id v12mr3847115eba.15.1228757598852; Mon, 08 Dec 2008 09:33:18 -0800 (PST) Received: from dhcp-212.svcs.mdw01.cymru.com ([75.145.179.110]) by mx.google.com with ESMTPS id 33sm10175006nfu.68.2008.12.08.09.33.16 (version=TLSv1/SSLv3 cipher=RC4-MD5); Mon, 08 Dec 2008 09:33:17 -0800 (PST) Message-Id: From: Charlie Reddington To: pgsql-admin@postgresql.org Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes Content-Transfer-Encoding: 7bit Mime-Version: 1.0 (Apple Message framework v929.2) Subject: how to grant SELECT access to a database? Date: Mon, 8 Dec 2008 11:33:14 -0600 X-Mailer: Apple Mail (2.929.2) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200812/59 X-Sequence-Number: 30892 Hi, I'm really new to PG, so if this is overly newbish, please send me to the appropriate tutorial. I have come from a mysql background, so giving access to for a user or app to just read the appropriate mail list was easy with something like 'grant select on DB to USER;'. I have found I can grant ALL PRIVILEGES, but not just select to a particular DB. I can use some hand holding here to grant read only to a db the right way, as I rather not just do a grant all privs. FYI, granting to a particular set of tables will not work, as we have a 'dynamic' db. Thanks for the help,