Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 6D9FA632CB6 for ; Tue, 3 Feb 2009 21:29:00 -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 57297-04 for ; Tue, 3 Feb 2009 21:28:48 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sabrina.lunarpages.com (sabrina.lunarpages.com [74.50.28.195]) by mail.postgresql.org (Postfix) with ESMTP id C7EB1632A38 for ; Tue, 3 Feb 2009 21:28:48 -0400 (AST) Received: from c-76-113-62-16.hsd1.nm.comcast.net ([76.113.62.16] helo=[192.168.0.103]) by sabrina.lunarpages.com with esmtpa (Exim 4.69) (envelope-from ) id 1LUWZJ-0000E8-8t for pgsql-admin@postgresql.org; Tue, 03 Feb 2009 17:28:45 -0800 Message-ID: <4988EF4A.8070701@djs-consulting.com> Date: Tue, 03 Feb 2009 18:28:42 -0700 From: "Daniel J. Summers" Organization: DJS Consulting User-Agent: Thunderbird 2.0.0.19 (X11/20090105) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Re: Permissions to a schema References: In-Reply-To: Content-Type: text/plain; charset=windows-1252; format=flowed Content-Transfer-Encoding: 8bit X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - sabrina.lunarpages.com X-AntiAbuse: Original Domain - postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12] X-AntiAbuse: Sender Address Domain - djs-consulting.com X-Source: X-Source-Args: X-Source-Dir: 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: 200902/29 X-Sequence-Number: 31250 Campbell, Lance wrote: > > How do I do the following: > > 1) Create a user group. > > 2) Assign access to select, delete, insert, and update to any table > found in the following X number of schemas. > > 3) Assign the newly created user group permissions to a new user. > When you're going through the tables, don't forget the sequences for any "serial" fields you may have. You'll get errors trying to insert, even though you've granted INSERT on that table. As best I can tell (haven't seen this in a document anywhere), your role needs SELECT and UPDATE on those sequences. -- Daniel J. Summers *Owner, DJS Consulting* Support • Tech Blog daniel@djs-consulting.com • http://www.djs-consulting.com GEEKCODE 3.12 GCS/IT d s-:+ a C++ L++ E--- W++ N++ o? K- w !O M-- V PS+ PE++ Y? !PGP t+ 5? X+ R* tv b+ DI++ D+ G- e h---- r+++ y++++