Thread: Grant question..
During the Design and Test Phase of some of my tables's we are droping tables and recreating them quit often.. I have tocontinually regrant privileges to different users.. is there a way to give someone general permissions that they will havegrant 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.. Travis
I'm trying to get around regranting permsissions after a table is created.. i.e. by default users a b & c have grant all to all new tables created.. Travis -----Original Message----- From: Francisco J Reyes [mailto:fran@natserv.net] Sent: Wednesday, November 20, 2002 11:21 AM To: Williams, Travis L, NPONS Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] 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>;
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 tocontinually regrant privileges to different users.. is there a way to give someone general permissions that they will havegrant 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>;