Re: Grant question..

On Wed, 20 Nov 2002, Williams, Travis L, NPONS wrote:

> During the Design and Test Phase of some of my tables's we are droping tables and recreating them quit often.. I have to continually regrant privileges to different users.. is there a way to give someone general permissions that they will have grant all to every DB that is created by default.. maybe by setting some kind of grant on a template or something?
> Thanks for the help..

Create groups, add users as needed to appropriate groups.
After you rebuild a table just grant .. to group $$$.

An example from one of my *.sql files:
revoke all on <table> from public;
grant select on <table> to group <group>;