Well this is my first post to this list, so be gentle ;-).  I have
written a small utility I use and wanted to get it out and better
tested :-)

With it you should be able to do most group amin, without going into psql.  
It has the following syntax:

usage: pg_group options -- dB group [user ...] || [table ...]
where options is one of:
  -c create group
  -d delete group
  -a add user(s) to group
  -r remove user(s) to group
  +g give group access to tables
  -g revoke group access to tables
  -p privlages to grant/revoke. This is only used with the +g and -g
     options.
  -- end of switches.
 
  examples:
  pg_group -c -- guestbook grp_gstbook_usr nobody tux
  pg_group -a -- guestbook grp_gstbook_usr webuser
  pg_group -d -- guestbook grp_gstbook_usr
  pg_group -r -- guestbook grp_gstbook_usr nobody
  pg_group +g -p "insert,select" -- guestbook grp_gstbook_usr gstbook
  pg_group -g -p "insert" -- guestbook grp_gstbook_usr gstbook
 
you can get it from: http://www.lowcountry.com/~jscottb/pg_group.tar.gz

If you have any questions, comments, patches or total rewrites email me
at: jscottb@infoave.com
 
scott


Fri, 10 Dec 1999 13:52:36 -0500 (EST)
Scott Beasley <jscottb@infoave.com>
First draft of pg_group admin tool.
On 1999-12-10, Scott Beasley mentioned:

> Well this is my first post to this list, so be gentle ;-).  I have
> written a small utility I use and wanted to get it out and better
> tested :-)

So you might want to send the news to pgsql-general as well.

The proper fix for this would of course be a CREATE GROUP command, but no
one has been willing to work on that. Until then, more power to you. ;)

-- 
Peter Eisentraut                  Sernanders vï¿½g 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden



Sat, 11 Dec 1999 03:00:31 +0100 (CET)
Peter Eisentraut <peter_e@gmx.net>
Re: [HACKERS] First draft of pg_group admin tool.