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 --- [EMAIL PROTECTED] ***
------------------------------------------------------------------------

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply via email to