changing default object rights

From: Dmitry Morozovsky <marck(at)rinet(dot)ru>
To: pgsql-admin(at)postgresql(dot)org
Subject: changing default object rights
Date: 2008-02-10 15:15:39
Message-ID: 20080210180901.C49763@woozle.rinet.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)FreeBSD(dot)org ]
------------------------------------------------------------------------
*** Dmitry Morozovsky --- D.Marck --- Wild Woozle --- marck(at)rinet(dot)ru ***
------------------------------------------------------------------------

Browse pgsql-admin by date

  From Date Subject
Next Message Dean Gibson (DB Administrator) 2008-02-10 17:30:22 Getting "ERROR: canceling autovacuum task"
Previous Message Tom Lane 2008-02-10 06:11:00 Re: When to ANALYZE w/ auto-vacuum