changing default object rights - Mailing list pgsql-admin

From Dmitry Morozovsky
Subject changing default object rights
Date
Msg-id 20080210180901.C49763@woozle.rinet.ru
Whole thread Raw
List pgsql-admin
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 ***
------------------------------------------------------------------------

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: When to ANALYZE w/ auto-vacuum
Next
From: "Dean Gibson (DB Administrator)"
Date:
Subject: Getting "ERROR: canceling autovacuum task"