Skip site navigation (1) Skip section navigation (2)

First draft of pg_group admin tool.

From: Scott Beasley <jscottb(at)infoave(dot)com>
To: pgsql-admin(at)postgresql(dot)org, pgsql-announce(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject: First draft of pg_group admin tool.
Date: 1999-12-11 02:46:07
Message-ID: Pine.LNX.4.10.9912102133460.1160-100000@cowbox.infoave.com (view raw or flat)
Thread:
Lists: pgsql-announcepgsql-general
I have a small tool I have written to do admin work on pg_group.  With it
I hope we will be able to do most group admin without going into psql.
Like I said, it is a first draft, so it may have a bug or two :-)

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(at)infoave(dot)com

scott


pgsql-announce by date

Next:From: Kevin LoDate: 1999-12-21 15:38:43
Subject: Announce: PostgreSQL-6.5.3 binaries available for Windows NT
Previous:From: hao fengDate: 1999-12-06 02:47:28
Subject:

pgsql-general by date

Next:From: Differentiated Software Solutions Pvt. Ltd.Date: 1999-12-11 07:03:31
Subject: Spin lock error
Previous:From: Peter EisentrautDate: 1999-12-11 02:00:12
Subject: Re: Mirroring a DB

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group