Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 999F32E2D22 for ; Sun, 10 Feb 2008 11:15:46 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 26559-07 for ; Sun, 10 Feb 2008 11:15:33 -0400 (AST) Received: from woozle.rinet.ru (woozle.rinet.ru [195.54.192.68]) by postgresql.org (Postfix) with ESMTP id 2EC792E25E8 for ; Sun, 10 Feb 2008 11:15:41 -0400 (AST) Received: from localhost (localhost [127.0.0.1]) by woozle.rinet.ru (8.14.1/8.14.1) with ESMTP id m1AFFdCf065365 for ; Sun, 10 Feb 2008 18:15:39 +0300 (MSK) (envelope-from marck@rinet.ru) Date: Sun, 10 Feb 2008 18:15:39 +0300 (MSK) From: Dmitry Morozovsky To: pgsql-admin@postgresql.org Subject: changing default object rights Message-ID: <20080210180901.C49763@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]); Sun, 10 Feb 2008 18:15:39 +0300 (MSK) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/122 X-Sequence-Number: 28196 Dear colleagues, For the last few hours I tried to implement $subj, to no avail. I tried to use create rule (no grant statement allowed), create function (syntax error on $1), etc. I have roles mng and rdr, and want that any newly created class (table, view, seq, index) will be available for wrining to mng and for queriyng to rdr. Any hints? Thanks in advance. Sincerely, D.Marck [DM5020, MCK-RIPE, DM3-RIPN] [ FreeBSD committer: marck@FreeBSD.org ] ------------------------------------------------------------------------ *** Dmitry Morozovsky --- D.Marck --- Wild Woozle --- marck@rinet.ru *** ------------------------------------------------------------------------