grant model in PostgreSQL 8.2

From: Dmitry Morozovsky <marck(at)rinet(dot)ru>
To: pgsql-admin(at)postgresql(dot)org
Subject: grant model in PostgreSQL 8.2
Date: 2007-02-19 18:30:07
Message-ID: 20070219212350.A45317@woozle.rinet.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(at)rinet(dot)ru ***
------------------------------------------------------------------------

Browse pgsql-admin by date

  From Date Subject
Next Message Ray Stell 2007-02-19 20:06:32 dst 2007?
Previous Message Andy Shellam (Mailing Lists) 2007-02-19 16:39:39 Re: log_duration?