Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 59A309FB9B4 for ; Mon, 19 Feb 2007 14:38:45 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 05143-09 for ; Mon, 19 Feb 2007 14:38:39 -0400 (AST) X-Greylist: delayed 00:08:28.992645 by SQLgrey-1.7.4 Received: from woozle.rinet.ru (woozle.rinet.ru [195.54.192.68]) by postgresql.org (Postfix) with ESMTP id 03F569FB6D0 for ; Mon, 19 Feb 2007 14:38:39 -0400 (AST) Received: from localhost (localhost [127.0.0.1]) by woozle.rinet.ru (8.13.8/8.13.8) with ESMTP id l1JIU74C050547 for ; Mon, 19 Feb 2007 21:30:07 +0300 (MSK) (envelope-from marck@rinet.ru) Date: Mon, 19 Feb 2007 21:30:07 +0300 (MSK) From: Dmitry Morozovsky To: pgsql-admin@postgresql.org Subject: grant model in PostgreSQL 8.2 Message-ID: <20070219212350.A45317@woozle.rinet.ru> X-NCC-RegID: ru.rinet X-OpenPGP-Key-ID: 6B691B03 MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Greylist: Sender IP whitelisted, not delayed by milter-greylist-3.0 (woozle.rinet.ru [0.0.0.0]); Mon, 19 Feb 2007 21:30:07 +0300 (MSK) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.201 tagged_above=0 required=5 tests=BAYES_50, DNS_FROM_RFC_ABUSE X-Spam-Level: X-Archive-Number: 200702/272 X-Sequence-Number: 24737 Dear colleagues, What is the preferred grant model in multi-developers environment? I'm currently thinking of two groups, one is 'admin' and other is 'user', where real developers are members of the first group, with 'set role to admin' in pg_authid; report create user (used in web frontend, e.g.) is a member of the second group, having only read privileges from db objects. The question is: can I automatically grant read privileges on newly created objects in my schema? Thanks. Sincerely, D.Marck [DM5020, MCK-RIPE, DM3-RIPN] ------------------------------------------------------------------------ *** Dmitry Morozovsky --- D.Marck --- Wild Woozle --- marck@rinet.ru *** ------------------------------------------------------------------------