First draft of pg_group admin tool.

From: jscottb(at)www(dot)lowcountry(dot)com
To: pgsql-hackers(at)postgresql(dot)org
Cc: jscottb(at)infoave(dot)com
Subject: First draft of pg_group admin tool.
Date: 1999-12-10 14:49:15
Message-ID: Pine.LNX.4.10.9912100918480.2750-200000@www.lowcountry.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Well this is my first post to this list, so be gentle ;-). With it I hope
we will 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

I have attched the pg_group script src (it's in tcl), I hope It will make
it and it was not a bad thing to do so, if not 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

Attachment Content-Type Size
pg_group text/plain 12.4 KB

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 1999-12-10 14:59:27 Re: [HACKERS] 6.6 release
Previous Message D'Arcy J.M. Cain 1999-12-10 13:58:42 Re: [HACKERS] 6.6 release